March 21, 2016

複習

每次開始前

  • 打開GitHub桌面版
  • 打GitHub帳密與Git config資料
  • Clone上次交的作業回本機端(存到桌面)
  • 提示:左上角的+號,選Clone
  • 點兩下Clone回來的資料夾裡面的.Rproj

Debugging

可以執行程式碼

你之前的程式碼沒打完(不知道是哪裡沒打完的話,按Esc砍掉重練)

Debugging 2

  • R的錯誤訊息
    • Message:有可能的錯誤通知,程式會繼續執行
    • Warning:有錯誤,但是不會影響太多,程式還是會繼續執行
    • Error:有錯,而且無法繼續執行程式
    • Condition:可能會發生的情況
log(-1)
## Warning in log(-1): NaNs produced
## [1] NaN
mena(NA)
## Error in eval(expr, envir, enclos): could not find function "mena"

從上次的解答開始

記得先把NBA14-15的資料讀進來

if (!require('SportsAnalytics')){
    install.packages("SportsAnalytics")
    library(SportsAnalytics)
}
NBA1415<-fetch_NBAPlayerStatistics("14-15")
for(i in 1:nrow(NBA1415)){
    if(NBA1415[i,"GamesPlayed"]>70&NBA1415[i,"TotalPoints"]>1500){
        print(NBA1415[i,c("Name","Team","Position")])
    }
}
##               Name Team Position
## 9 Lamarcu Aldridge  POR       PF
##              Name Team Position
## 112 Stephen Curry  GSW       PG
##            Name Team Position
## 142 Monta Ellis  DAL       SG
##             Name Team Position
## 197 James Harden  HOU       SG
##             Name Team Position
## 231 Kyrie Irving  CLE       PG
##               Name Team Position
## 283 Damian Lillard  POR       PG
##           Name Team Position
## 361 Chris Paul  LAC       PG
##              Name Team Position
## 442 Klay Thompson  GSW       SG

都說了for不好用

  • For迴圈在R執行的效率極慢
  • 剛剛的問題:取出打超過70場,總得分超過1500分的球員姓名、所屬隊伍、守備位置。
  • 用subset() 一行搞定!
subset(NBA1415,GamesPlayed>70&
           TotalPoints>1500)[,c("Name","Team","Position")]
##                 Name Team Position
## 9   Lamarcu Aldridge  POR       PF
## 112    Stephen Curry  GSW       PG
## 142      Monta Ellis  DAL       SG
## 197     James Harden  HOU       SG
## 231     Kyrie Irving  CLE       PG
## 283   Damian Lillard  POR       PG
## 361       Chris Paul  LAC       PG
## 442    Klay Thompson  GSW       SG

都說了for不好用-2

Data Frame的subset [ ] 也可以一行搞定!

NBA1415[NBA1415$GamesPlayed>70&
            NBA1415$TotalPoints>1500,
        c("Name","Team","Position")]
##                 Name Team Position
## 9   Lamarcu Aldridge  POR       PF
## 112    Stephen Curry  GSW       PG
## 142      Monta Ellis  DAL       SG
## 197     James Harden  HOU       SG
## 231     Kyrie Irving  CLE       PG
## 283   Damian Lillard  POR       PG
## 361       Chris Paul  LAC       PG
## 442    Klay Thompson  GSW       SG

可是….還是有想用for的時候啊….

想起上次上課…馬刺隊得分最高的好像是…

San<-subset(NBA1415,Team=='SAN')
order(San$TotalPoints,decreasing = T)
##  [1]  7 11 13  9  8  6  4 10  3 14 12  5  2  1 15
San[order(San$TotalPoints,decreasing = T)[1],
    c("Name","Team","TotalPoints")]
##           Name Team TotalPoints
## 137 Tim Duncan  SAN        1070

如果要得到每隊最高分的球員名單呢?

我們還是用for+unique()試試看好了

NBA14-15球季,每隊最高分的球員名單

unique(NBA1415$Team)
##  [1] NYK MEM OKL MIN POR NOR PHI IND DAL MIA BRO SAN MIL DET ATL HOU DEN
## [18] CHI GSW LAC PHO BOS WAS UTA SAC CHA LAL TOR CLE ORL
## 30 Levels: ATL BOS BRO CHA CHI CLE DAL DEN DET GSW HOU IND LAC LAL ... WAS
for(team in unique(NBA1415$Team)){
    selectTeam<-subset(NBA1415,Team==team)
    print(selectTeam[order(selectTeam$TotalPoints,decreasing = T)[1],
                               c("Name","Team","TotalPoints")])
}
##               Name Team TotalPoints
## 19 Carmelo Anthony  NYK         966
##           Name Team TotalPoints
## 166 Marc Gasol  MEM        1413
##                 Name Team TotalPoints
## 470 Russel Westbrook  OKL        1886
##               Name Team TotalPoints
## 473 Andrew Wiggins  MIN        1387
##               Name Team TotalPoints
## 283 Damian Lillard  POR        1720
##              Name Team TotalPoints
## 117 Anthony Davis  NOR        1656
##                 Name Team TotalPoints
## 105 Robert Covington  PHI         927
##           Name Team TotalPoints
## 317 C.j. Miles  IND         942
##            Name Team TotalPoints
## 142 Monta Ellis  DAL        1513
##            Name Team TotalPoints
## 458 Dwyane Wade  MIA        1331
##            Name Team TotalPoints
## 286 Brook Lopez  BRO        1236
##           Name Team TotalPoints
## 137 Tim Duncan  SAN        1070
##                Name Team TotalPoints
## 316 Khris Middleton  MIL        1055
##               Name Team TotalPoints
## 135 Andre Drummond  DET        1130
##             Name Team TotalPoints
## 324 Paul Millsap  ATL        1218
##             Name Team TotalPoints
## 197 James Harden  HOU        2217
##          Name Team TotalPoints
## 274 Ty Lawson  DEN        1143
##          Name Team TotalPoints
## 167 Pau Gasol  CHI        1446
##              Name Team TotalPoints
## 112 Stephen Curry  GSW        1900
##           Name Team TotalPoints
## 361 Chris Paul  LAC        1564
##            Name Team TotalPoints
## 52 Eric Bledsoe  PHO        1377
##              Name Team TotalPoints
## 436 Isaiah Thomas  BOS        1101
##          Name Team TotalPoints
## 462 John Wall  WAS        1385
##               Name Team TotalPoints
## 206 Gordon Hayward  UTA        1463
##         Name Team TotalPoints
## 168 Rudy Gay  SAC        1432
##             Name Team TotalPoints
## 236 Al Jefferson  CHA        1080
##            Name Team TotalPoints
## 215 Jordan Hill  LAL         841
##           Name Team TotalPoints
## 289 Kyle Lowry  TOR        1244
##             Name Team TotalPoints
## 235 Lebron James  CLE        1740
##               Name Team TotalPoints
## 457 Nikola Vucevic  ORL        1428

用rbind()把輸出整理成一個Data Frame

FinalOutput<-NULL
for(team in unique(NBA1415$Team)){
    selectTeam<-subset(NBA1415,Team==team)
    FinalOutput<-rbind(FinalOutput,
                       selectTeam[
                           order(selectTeam$TotalPoints,decreasing = T)[1],
                               c("Name","Team","TotalPoints")])
}
FinalOutput
##                 Name Team TotalPoints
## 19   Carmelo Anthony  NYK         966
## 166       Marc Gasol  MEM        1413
## 470 Russel Westbrook  OKL        1886
## 473   Andrew Wiggins  MIN        1387
## 283   Damian Lillard  POR        1720
## 117    Anthony Davis  NOR        1656
## 105 Robert Covington  PHI         927
## 317       C.j. Miles  IND         942
## 142      Monta Ellis  DAL        1513
## 458      Dwyane Wade  MIA        1331
## 286      Brook Lopez  BRO        1236
## 137       Tim Duncan  SAN        1070
## 316  Khris Middleton  MIL        1055
## 135   Andre Drummond  DET        1130
## 324     Paul Millsap  ATL        1218
## 197     James Harden  HOU        2217
## 274        Ty Lawson  DEN        1143
## 167        Pau Gasol  CHI        1446
## 112    Stephen Curry  GSW        1900
## 361       Chris Paul  LAC        1564
## 52      Eric Bledsoe  PHO        1377
## 436    Isaiah Thomas  BOS        1101
## 462        John Wall  WAS        1385
## 206   Gordon Hayward  UTA        1463
## 168         Rudy Gay  SAC        1432
## 236     Al Jefferson  CHA        1080
## 215      Jordan Hill  LAL         841
## 289       Kyle Lowry  TOR        1244
## 235     Lebron James  CLE        1740
## 457   Nikola Vucevic  ORL        1428

問題?

Apply家族介紹

apply()

有類似for迴圈的功能

  • apply(Data, MARGIN, FUN,….)
    • Data:矩陣(Matrix),Data Frame
    • MARGIN:1=row, 2=column
    • FUN:函數
    • …:函數要用的參數 NBA1415的各列中,最大值是多少
apply(NBA1415,2,max)
##              League                Name                Team 
##               "NBA"      "Zoran Dragic"               "WAS" 
##            Position         GamesPlayed  TotalMinutesPlayed 
##                "SG"                "83"              "2979" 
##      FieldGoalsMade FieldGoalsAttempted          ThreesMade 
##               "659"              "1471"               "286" 
##     ThreesAttempted      FreeThrowsMade FreeThrowsAttempted 
##               "646"               "715"               "824" 
##   OffensiveRebounds       TotalRebounds             Assists 
##               "437"              "1226"               "838" 
##              Steals           Turnovers              Blocks 
##               "163"               "321"               "200" 
##       PersonalFouls   Disqualifications         TotalPoints 
##               "285"                "10"              "2217" 
##          Technicals           Ejections       FlagrantFouls 
##                "15"                 "1"                 "0" 
##        GamesStarted 
##                "82"

apply()範例2

NBA1415球季,出場數、出場總分鐘數、總分的最大值各是多少

apply(NBA1415[,c("GamesPlayed","TotalMinutesPlayed","TotalPoints")]
      ,2,mean)
##        GamesPlayed TotalMinutesPlayed        TotalPoints 
##           52.81707         1210.46341          499.95935

未來用得上的apply()快速功能

  • rowSums = apply(x, 1, sum)
  • rowMeans = apply(x, 1, mean)
  • colSums = apply(x, 2, sum)
  • colMeans = apply(x, 2, mean)

sapply(): Simplify

  • 如果回傳的list裡面,每個欄位長度都是1,回傳向量
  • 如果回傳的list裡面,每個欄位長度都一樣,回傳矩陣
  • sapply(Data, FUN…)
    • Data:矩陣(Matrix),Data Frame,List向量
    • FUN:函數
    • …:函數要用的參數
sapply(iris, mean)
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## Sepal.Length  Sepal.Width Petal.Length  Petal.Width      Species 
##     5.843333     3.057333     3.758000     1.199333           NA

sapply()範例2

NBA1415球季,出場數、出場總分鐘數、總分的平均值各是多少

sapply(NBA1415[,c("GamesPlayed","TotalMinutesPlayed","TotalPoints")],
       mean)
##        GamesPlayed TotalMinutesPlayed        TotalPoints 
##           52.81707         1210.46341          499.95935

等同於

apply(NBA1415[,c("GamesPlayed","TotalMinutesPlayed","TotalPoints")]
      ,2,mean)
##        GamesPlayed TotalMinutesPlayed        TotalPoints 
##           52.81707         1210.46341          499.95935

lapply(): List

  • For List
  • C code
  • lapply(Data, FUN…)
    • Data:矩陣(Matrix),Data Frame,List
    • FUN:函數
    • …:函數要用的參數
lapply(iris, mean)
## Warning in mean.default(X[[i]], ...): argument is not numeric or logical:
## returning NA
## $Sepal.Length
## [1] 5.843333
## 
## $Sepal.Width
## [1] 3.057333
## 
## $Petal.Length
## [1] 3.758
## 
## $Petal.Width
## [1] 1.199333
## 
## $Species
## [1] NA

lapply()範例2

NBA1415球季,出場數、出場總分鐘數、總分的平均值各是多少

lapply(NBA1415[,c("GamesPlayed","TotalMinutesPlayed","TotalPoints")],
       mean)
## $GamesPlayed
## [1] 52.81707
## 
## $TotalMinutesPlayed
## [1] 1210.463
## 
## $TotalPoints
## [1] 499.9593

tapply()

向量分群後計算

  • tapply(Data, INDEX, FUN,…)
    • Data:向量
    • INDEX:分類因子
    • FUN:函數
    • …:函數要用的參數
tapply(NBA1415$Name,NBA1415$Team,length)
## ATL BOS BRO CHA CHI CLE DAL DEN DET GSW HOU IND LAC LAL MEM MIA MIL MIN 
##  15  15  17  16  14  16  16  15  15  15  16  15  19  18  17  18  17  20 
## NOR NYK OKL ORL PHI PHO POR SAC SAN TOR UTA WAS 
##  19  16  16  15  19  16  16  17  15  15  17  17

split(), tapply()的朋友

有tapply()的部分功能:替向量做分群

1到30的向量,用第二個參數做分群

split(1:30,gl(3, 10))
## $`1`
##  [1]  1  2  3  4  5  6  7  8  9 10
## 
## $`2`
##  [1] 11 12 13 14 15 16 17 18 19 20
## 
## $`3`
##  [1] 21 22 23 24 25 26 27 28 29 30

輸出結果是List—>應該要想到lapply()

split()+lapply()

split()分群後的向量,用lapply()做運算

lapply(split(1:30,gl(3, 10)),mean)
## $`1`
## [1] 5.5
## 
## $`2`
## [1] 15.5
## 
## $`3`
## [1] 25.5

效果等同於

tapply(1:30,gl(3, 10),mean)
##    1    2    3 
##  5.5 15.5 25.5

Data Frame也可以split()

替Data Frame做分群

  • split(Data, 分群依據)
NBA1415Team<-split(NBA1415[,c("TotalPoints","GamesPlayed")],
                   NBA1415$Team)
NBA1415Team
## $ATL
##     TotalPoints GamesPlayed
## 21          356          63
## 40          390          75
## 61           96          36
## 84          883          71
## 121         129          35
## 222        1156          76
## 239         135          24
## 266         911          75
## 292         299          55
## 324        1218          73
## 338         197          40
## 401         768          77
## 403         529          68
## 404         278          52
## 431        1162          73
## 
## $BOS
##     TotalPoints GamesPlayed
## 36          866          82
## 60         1071          77
## 108         628          82
## 115         105          21
## 241         448          75
## 352         656          64
## 372         177          50
## 379          24          21
## 412         523          67
## 429         770          58
## 436        1101          67
## 449         779          82
## 463          35          32
## 488         105          31
## 492         833          82
## 
## $BRO
##     TotalPoints GamesPlayed
## 15          543          74
## 54          700          78
## 66          216          47
## 93           20           9
## 116         142          27
## 232         957          80
## 237         183          50
## 246        1154          80
## 255         138          44
## 259         153          33
## 263           3           7
## 286        1236          72
## 330          81          37
## 367         717          82
## 432         339          40
## 475         886          68
## 490        1069          76
## 
## $CHA
##     TotalPoints GamesPlayed
## 48          304          64
## 114         176          47
## 192         254          45
## 208         969          80
## 236        1080          65
## 261         598          55
## 301         203          61
## 356          41           9
## 387         480          72
## 423         501          61
## 430         127          29
## 456          83          25
## 461        1075          62
## 479         579          78
## 480         964          68
## 491         472          62
## 
## $CHI
##     TotalPoints GamesPlayed
## 28           10          18
## 63          954          82
## 74         1301          65
## 138         595          63
## 167        1446          78
## 171         642          62
## 217         377          66
## 308         109          36
## 325         833          82
## 326          25          23
## 328         149          56
## 343         485          67
## 392         904          51
## 419         435          72
## 
## $CLE
##     TotalPoints GamesPlayed
## 91           15           8
## 123         305          67
## 201         136          50
## 207          35          22
## 231        1622          75
## 235        1740          69
## 251         244          57
## 264           4           5
## 288        1238          76
## 295         278          58
## 320         109          52
## 335         792          81
## 407         488          62
## 415         844          70
## 443         691          82
## 453         255          26
## 
## $DAL
##     TotalPoints GamesPlayed
## 12          412          74
## 30          580          77
## 89          771          75
## 142        1513          80
## 153         108          29
## 199         665          76
## 234          44          16
## 238         432          74
## 347        1333          77
## 359        1037          66
## 365         242          68
## 371          90          29
## 391         608          68
## 413          80          42
## 427         680          59
## 455         403          64
## 
## $DEN
##     TotalPoints GamesPlayed
## 23          382          58
## 35          397          58
## 90         1085          78
## 94           57          30
## 150         946          75
## 156         435          51
## 157           3           3
## 162         734          59
## 185         146          43
## 200         188          55
## 212         552          73
## 272          93          24
## 274        1143          75
## 341         523          63
## 348         426          62
## 
## $DET
##     TotalPoints GamesPlayed
## 20           87          49
## 73          460          78
## 81         1043          82
## 128         145          34
## 135        1130          82
## 233        1117          77
## 240         632          41
## 290          98          21
## 297          36          23
## 314         663          60
## 321          29          10
## 327        1098          69
## 376         434          58
## 445         482          76
## 482         341          63
## 
## $GSW
##     TotalPoints GamesPlayed
## 29          467          66
## 32          827          82
## 55          422          67
## 112        1900          80
## 149         201          46
## 184         921          79
## 219         254          59
## 228         604          77
## 268          20          16
## 277         388          49
## 285         461          78
## 304          62          15
## 396          30          33
## 420         791          76
## 442        1668          77
## 
## $HOU
##     TotalPoints GamesPlayed
## 22         1048          82
## 46          568          56
## 62          917          80
## 83           32          12
## 129         184          69
## 164          45          14
## 197        2217          81
## 223         646          41
## 247          74          28
## 253         386          33
## 307         487          62
## 334         855          71
## 355         182          43
## 375         274          67
## 417        1027          83
## 435         541          77
## 
## $IND
##     TotalPoints GamesPlayed
## 10          317          63
## 102         309          50
## 170          53           6
## 211         802          76
## 214         692          43
## 216         729          82
## 293         263          61
## 317         942          70
## 395         323          68
## 402         761          81
## 411         393          53
## 428         896          71
## 465         570          57
## 469         769          66
## 472          57          20
## 
## $LAC
##     TotalPoints GamesPlayed
## 33          764          76
## 107        1010          64
## 110          35          19
## 119         294          74
## 131          19          12
## 151         167          36
## 190        1469          67
## 193          38          14
## 204         425          73
## 224          18           5
## 250          21          33
## 254         946          82
## 361        1564          82
## 381        1277          78
## 385         530          76
## 389         238          42
## 448         232          62
## 450          29          33
## 474          41          21
## 
## $LAL
##     TotalPoints GamesPlayed
## 49          379          63
## 53           22           2
## 58          836          71
## 64          227          19
## 68          782          35
## 76           52           6
## 95          703          59
## 118         656          79
## 141         650          65
## 209          20           9
## 215         841          70
## 249         753          76
## 260         332          52
## 284         832          74
## 374         221          43
## 378           2           1
## 397         307          67
## 489         563          42
## 
## $MEM
##     TotalPoints GamesPlayed
## 2            94          30
## 11          539          63
## 79          243          58
## 85          384          66
## 100        1107          70
## 166        1413          81
## 187          62          24
## 188        1168          78
## 267         419          81
## 276         777          77
## 282         286          63
## 291           0           1
## 380        1143          71
## 418          30          12
## 426          57          19
## 439           4           2
## 451         605          79
## 
## $MIA
##     TotalPoints GamesPlayed
## 14          320          60
## 42          212          24
## 59          928          44
## 67           20           5
## 88          813          80
## 120           3           4
## 124        1007          72
## 132        1275          78
## 133          28          16
## 143         312          62
## 181         188          31
## 203         261          62
## 248         190          32
## 313          72          17
## 339         261          51
## 458        1331          62
## 460         175          24
## 471         564          48
## 
## $MIL
##     TotalPoints GamesPlayed
## 18         1030          81
## 38          598          77
## 86          966          67
## 136         518          72
## 144         121          33
## 191          53          20
## 210         471          67
## 229         669          58
## 296         118          28
## 298          20          11
## 302         806          71
## 316        1055          79
## 349         100          34
## 354         606          73
## 357         308          25
## 368         294          73
## 400         196          27
## 
## $MIN
##     TotalPoints GamesPlayed
## 4            60          17
## 45          298          57
## 65          122          29
## 69          457          67
## 127         710          73
## 165         323          47
## 194         219          41
## 225         198          45
## 262          22           4
## 273         778          77
## 299         781          39
## 336         512          38
## 340         543          54
## 353          27           6
## 362         213          32
## 364         386          31
## 377           8           5
## 394         226          22
## 447           0           2
## 473        1387          82
## 
## $NOR
##     TotalPoints GamesPlayed
## 6           443          68
## 17          833          61
## 24          557          77
## 27          256          63
## 97          573          75
## 109         340          66
## 117        1656          68
## 130          51          12
## 147        1313          79
## 159         178          50
## 179         818          61
## 218         592          40
## 315           6           4
## 319           2           5
## 369         538          75
## 398          42          21
## 477          37          13
## 483          98          37
## 484          42          21
## 
## $NYK
##     TotalPoints GamesPlayed
## 1           398          68
## 8           338          61
## 13          259          53
## 19          966          40
## 31          430          29
## 80          382          42
## 113         128          32
## 140         210          39
## 163         533          45
## 196         804          70
## 271         470          76
## 275          90          17
## 408         434          42
## 416         656          82
## 437         443          62
## 467         199          51
## 
## $OKL
##     TotalPoints GamesPlayed
## 3           537          70
## 25          777          82
## 99          273          66
## 139         686          27
## 227         917          64
## 252         187          43
## 258        1163          75
## 269         295          47
## 309         201          32
## 333         790          74
## 346          63          35
## 386         228          68
## 410         480          80
## 433         131          16
## 459         940          80
## 470        1886          67
## 
## $ORL
##     TotalPoints GamesPlayed
## 122         216          59
## 155         698          58
## 161         549          75
## 176         243          47
## 177         349          56
## 189         306          52
## 198         158          45
## 202        1164          68
## 294          37          16
## 342         194          40
## 350         294          51
## 351        1292          72
## 363         731          82
## 384         188          47
## 457        1428          74
## 
## $PHI
##     TotalPoints GamesPlayed
## 7            93          41
## 82          432          48
## 105         927          69
## 134          46          12
## 178          17           9
## 182         411          65
## 278           0           1
## 303         660          67
## 310         106          23
## 344         744          75
## 383         172          19
## 388          73          35
## 390         308          54
## 399         386          74
## 409         586          73
## 414         338          55
## 438          45          17
## 440         626          71
## 487         507          30
## 
## $PHO
##     TotalPoints GamesPlayed
## 34           32          16
## 52         1377          81
## 70           69          36
## 111           0           2
## 175         231          41
## 186         884          74
## 265        1070          63
## 279         432          69
## 312           9           6
## 331         845          81
## 332        1258          82
## 373         131          25
## 444         380          48
## 446         713          78
## 464         245          40
## 485         544          75
## 
## $POR
##     TotalPoints GamesPlayed
## 5          1035          78
## 9          1661          71
## 37          664          71
## 51          350          81
## 96           24          10
## 106         168          51
## 158          57          11
## 160         169          48
## 169         241          54
## 257         638          74
## 281         327          55
## 283        1720          82
## 287         566          59
## 300         956          60
## 306         424          62
## 486         219          48
## 
## $SAC
##     TotalPoints GamesPlayed
## 47            2           3
## 87          593          67
## 98          725          45
## 104        1421          59
## 146         176          47
## 168        1432          68
## 220         137          46
## 270         503          70
## 305         503          68
## 311         996          82
## 318         355          81
## 329           2           3
## 422         319          73
## 425           8           3
## 441         491          81
## 466           0           2
## 476         617          74
## 
## $SAN
##     TotalPoints GamesPlayed
## 16           74          33
## 26          137          51
## 39          461          70
## 43          568          62
## 56          264          72
## 126         708          81
## 137        1070          77
## 172         738          70
## 183         946          81
## 256         535          79
## 280        1057          64
## 322         351          51
## 358         976          68
## 421         428          52
## 481          37          20
## 
## $TOR
##     TotalPoints GamesPlayed
## 78           10           8
## 125        1204          60
## 154          46          26
## 195         270          74
## 205          50          29
## 243         694          75
## 245         554          70
## 289        1244          70
## 345           4           4
## 360         648          81
## 393         807          82
## 424          14          17
## 452         963          80
## 454         775          82
## 478        1242          80
## 
## $UTA
##     TotalPoints GamesPlayed
## 44            0           2
## 57          567          79
## 71          973          76
## 72          374          27
## 92            6           4
## 101          27          16
## 103          80          16
## 145          90          38
## 148         393          82
## 152        1187          74
## 173         686          82
## 206        1463          76
## 221         433          50
## 230         396          79
## 242          16           8
## 244         166          29
## 323         248          47
## 
## $WAS
##     TotalPoints GamesPlayed
## 41          964          63
## 50           56          29
## 75          580          75
## 77           22           7
## 174         277          51
## 180        1001          82
## 213         737          68
## 226         509          64
## 337           6           5
## 366         868          73
## 370         445          74
## 382          11           5
## 405         520          79
## 406         402          64
## 434         204          52
## 462        1385          79
## 468         106          32

split()搭配apply()家族使用

lapply(NBA1415Team, colMeans) #回傳List
## $ATL
## TotalPoints GamesPlayed 
##   567.13333    59.53333 
## 
## $BOS
## TotalPoints GamesPlayed 
##       541.4        59.4 
## 
## $BRO
## TotalPoints GamesPlayed 
##   502.17647    53.17647 
## 
## $CHA
## TotalPoints GamesPlayed 
##    494.1250     55.1875 
## 
## $CHI
## TotalPoints GamesPlayed 
##   590.35714    58.64286 
## 
## $CLE
## TotalPoints GamesPlayed 
##      549.75       53.75 
## 
## $DAL
## TotalPoints GamesPlayed 
##     562.375      60.875 
## 
## $DEN
## TotalPoints GamesPlayed 
##       474.0        53.8 
## 
## $DET
## TotalPoints GamesPlayed 
##   519.66667    54.86667 
## 
## $GSW
## TotalPoints GamesPlayed 
##    601.0667     60.0000 
## 
## $HOU
## TotalPoints GamesPlayed 
##    592.6875     56.1875 
## 
## $IND
## TotalPoints GamesPlayed 
##    525.0667     57.8000 
## 
## $LAC
## TotalPoints GamesPlayed 
##   479.84211    49.94737 
## 
## $LAL
## TotalPoints GamesPlayed 
##   454.33333    46.27778 
## 
## $MEM
## TotalPoints GamesPlayed 
##   490.05882    51.47059 
## 
## $MIA
## TotalPoints GamesPlayed 
##   442.22222    42.88889 
## 
## $MIL
## TotalPoints GamesPlayed 
##   466.41176    52.70588 
## 
## $MIN
## TotalPoints GamesPlayed 
##       363.5        38.4 
## 
## $NOR
## TotalPoints GamesPlayed 
##   440.78947    47.15789 
## 
## $NYK
## TotalPoints GamesPlayed 
##    421.2500     50.5625 
## 
## $OKL
## TotalPoints GamesPlayed 
##     597.125      57.875 
## 
## $ORL
## TotalPoints GamesPlayed 
##   523.13333    56.13333 
## 
## $PHI
## TotalPoints GamesPlayed 
##   340.89474    44.10526 
## 
## $PHO
## TotalPoints GamesPlayed 
##    513.7500     51.0625 
## 
## $POR
## TotalPoints GamesPlayed 
##    576.1875     57.1875 
## 
## $SAC
## TotalPoints GamesPlayed 
##   487.05882    51.29412 
## 
## $SAN
## TotalPoints GamesPlayed 
##   556.66667    62.06667 
## 
## $TOR
## TotalPoints GamesPlayed 
##   568.33333    55.86667 
## 
## $UTA
## TotalPoints GamesPlayed 
##   417.94118    46.17647 
## 
## $WAS
## TotalPoints GamesPlayed 
##   476.05882    53.05882
sapply(NBA1415Team, colMeans) #回傳Data frame
##                   ATL   BOS       BRO      CHA       CHI    CLE     DAL
## TotalPoints 567.13333 541.4 502.17647 494.1250 590.35714 549.75 562.375
## GamesPlayed  59.53333  59.4  53.17647  55.1875  58.64286  53.75  60.875
##               DEN       DET      GSW      HOU      IND       LAC       LAL
## TotalPoints 474.0 519.66667 601.0667 592.6875 525.0667 479.84211 454.33333
## GamesPlayed  53.8  54.86667  60.0000  56.1875  57.8000  49.94737  46.27778
##                   MEM       MIA       MIL   MIN       NOR      NYK     OKL
## TotalPoints 490.05882 442.22222 466.41176 363.5 440.78947 421.2500 597.125
## GamesPlayed  51.47059  42.88889  52.70588  38.4  47.15789  50.5625  57.875
##                   ORL       PHI      PHO      POR       SAC       SAN
## TotalPoints 523.13333 340.89474 513.7500 576.1875 487.05882 556.66667
## GamesPlayed  56.13333  44.10526  51.0625  57.1875  51.29412  62.06667
##                   TOR       UTA       WAS
## TotalPoints 568.33333 417.94118 476.05882
## GamesPlayed  55.86667  46.17647  53.05882

split():用多個欄位來分群

想要同時針對隊伍和守備位置做分群呢?

用list將分群依據包起來

  • split(資料, list(分群依據1,分群依據2))
NBA1415TP<-split(NBA1415[,c("TotalPoints","GamesPlayed")],
                 list(NBA1415$Team,NBA1415$Position))
sapply(NBA1415TP, colMeans)#一樣可以用apply家族計算平均值
##             ATL.C BOS.C BRO.C     CHA.C CHI.C CLE.C    DAL.C DEN.C DET.C
## TotalPoints   NaN 744.5   687 618.66667   255 271.5 352.3333 489.0 608.5
## GamesPlayed   NaN  73.0    58  63.66667    45  33.5  53.0000  67.5  65.5
##                GSW.C HOU.C IND.C LAC.C LAL.C MEM.C MIA.C  MIL.C MIN.C
## TotalPoints 214.3333 339.0 532.5   946   307   916   442 391.75 264.6
## GamesPlayed  43.0000  26.5  68.5    82    67    81    54  60.00  30.4
##                 NOR.C NYK.C OKL.C ORL.C PHI.C PHO.C POR.C SAC.C SAN.C
## TotalPoints 366.00000   388 850.0 822.0   346   432   425   520   NaN
## GamesPlayed  60.66667    51  72.5  66.5    48    69    59    36   NaN
##              TOR.C UTA.C     WAS.C    ATL.PF BOS.PF BRO.PF    CHA.PF
## TotalPoints 257.75   686 525.66667 592.00000    527  280.2 288.33333
## GamesPlayed  32.50    82  63.33333  59.33333     59   41.6  54.66667
##             CHI.PF CLE.PF DAL.PF    DEN.PF    DET.PF GSW.PF HOU.PF IND.PF
## TotalPoints 732.75  964.5  624.0 473.66667 536.33333  589.5    613  476.0
## GamesPlayed  60.00   79.0   60.5  52.33333  51.66667   62.5     64   57.5
##             LAC.PF   LAL.PF MEM.PF MIA.PF    MIL.PF MIN.PF NOR.PF NYK.PF
## TotalPoints 554.25 507.6667  310.4 368.25 263.00000  184.2    943    259
## GamesPlayed  61.75  56.0000   35.8  36.75  34.33333   31.8     65     53
##               OKL.PF ORL.PF PHI.PF PHO.PF POR.PF    SAC.PF    SAN.PF
## TotalPoints 463.6667 320.00  265.5 669.75  842.5 298.16667 511.33333
## GamesPlayed  54.0000  53.25   45.0  63.50   40.5  46.16667  67.16667
##             TOR.PF UTA.PF   WAS.PF    ATL.PG BOS.PG    BRO.PG CHA.PG
## TotalPoints  541.5 442.50 507.6667 743.00000 718.00 641.33333 640.00
## GamesPlayed   75.0  40.75  61.0000  68.33333  65.25  61.66667  52.75
##             CHI.PG CLE.PG DAL.PG    DEN.PG DET.PG GSW.PG HOU.PG IND.PG
## TotalPoints  929.0  818.5 490.25 604.00000 498.00 1180.5  421.0 637.75
## GamesPlayed   66.5   41.5  62.50  60.33333  43.25   79.0   61.5  56.00
##             LAC.PG LAL.PG MEM.PG    MIA.PG MIL.PG MIN.PG    NOR.PG NYK.PG
## TotalPoints 497.50  452.0  435.5 364.66667  371.2 417.25 240.33333 454.75
## GamesPlayed  48.25   45.5   40.5  45.33333   45.0  45.50  33.66667  51.25
##               OKL.PG ORL.PG    PHI.PG PHO.PG POR.PG SAC.PG   SAN.PG TOR.PG
## TotalPoints 931.3333  459.5 272.00000 644.50    709 397.75 620.6667 1009.5
## GamesPlayed  55.0000   64.5  38.33333  42.75     58  49.25  66.0000   76.0
##                UTA.PG WAS.PG ATL.SF BOS.SF    BRO.SF CHA.SF   CHI.SF
## TotalPoints 475.66667    603    506    256 590.66667  362.5 379.6667
## GamesPlayed  39.66667     50     53     45  53.66667   42.0  57.0000
##             CLE.SF DAL.SF DEN.SF DET.SF GSW.SF HOU.SF IND.SF LAC.SF
## TotalPoints 592.75 492.75  909.5 317.75  874.0  549.5  353.5    498
## GamesPlayed  59.00  60.75   68.5  55.50   80.5   61.5   51.5     69
##                LAL.SF MEM.SF   MIA.SF MIL.SF MIN.SF NOR.SF NYK.SF OKL.SF
## TotalPoints 445.33333   1168 502.3333  681.5    389  209.5  443.2 354.00
## GamesPlayed  42.33333     78  55.0000   52.0     50   41.0   52.0  46.25
##             ORL.SF PHI.SF PHO.SF    POR.SF SAC.SF SAN.SF TOR.SF UTA.SF
## TotalPoints  661.0 517.75    479 374.66667 1012.5    547  408.5  428.4
## GamesPlayed   56.5  59.00     59  57.66667   67.5     42   45.0   47.6
##             WAS.SF ATL.SG BOS.SG BRO.SG CHA.SG    CHI.SG CLE.SG DAL.SG
## TotalPoints  401.0  428.5  442.0  516.5 475.00 609.00000 443.25   1513
## GamesPlayed   51.8   56.5   56.5   58.5  58.25  62.33333  62.25     80
##             DEN.SG DET.SG   GSW.SG    HOU.SG IND.SG  LAC.SG LAL.SG MEM.SG
## TotalPoints  216.0    853 514.1667 735.33333    942 371.000 420.25  407.4
## GamesPlayed   39.4     71  54.5000  57.33333     70  36.125  30.25   58.8
##               MIA.SG    MIL.SG    MIN.SG   NOR.SG NYK.SG OKL.SG ORL.SG
## TotalPoints 500.3333 784.66667 730.00000 722.6667  447.0 563.25  536.4
## GamesPlayed  36.0000  74.66667  41.66667  51.0000   43.5  67.25   50.8
##             PHI.SG PHO.SG POR.SG SAC.SG SAN.SG    TOR.SG UTA.SG WAS.SG
## TotalPoints 326.25  314.6 645.75  657.5  581.5 830.66667 270.00    393
## GamesPlayed  30.25   41.0  62.75   77.5   61.5  55.33333  45.75     40

apply家族的使用時機

  • apply:想要apply一個函數功能到陣列(Matrix)的行或列。不太建議在data frame使用
  • lapply:想要apply一個函數功能到List中,回傳List
  • sapply:同上,但想要回傳的東西是向量(Vector)
  • tapply:想要對一個向量分群,分群後apply一個函數功能

類似apply家族的函數:aggregate()

aggregate(資料, by=分組依據, FUN=函數功能)

aggregate(NBA1415$TotalPoints, 
          by=list(NBA1415$Team,NBA1415$Position), 
          FUN=mean)
##     Group.1 Group.2         x
## 1       BOS       C  744.5000
## 2       BRO       C  687.0000
## 3       CHA       C  618.6667
## 4       CHI       C  255.0000
## 5       CLE       C  271.5000
## 6       DAL       C  352.3333
## 7       DEN       C  489.0000
## 8       DET       C  608.5000
## 9       GSW       C  214.3333
## 10      HOU       C  339.0000
## 11      IND       C  532.5000
## 12      LAC       C  946.0000
## 13      LAL       C  307.0000
## 14      MEM       C  916.0000
## 15      MIA       C  442.0000
## 16      MIL       C  391.7500
## 17      MIN       C  264.6000
## 18      NOR       C  366.0000
## 19      NYK       C  388.0000
## 20      OKL       C  850.0000
## 21      ORL       C  822.0000
## 22      PHI       C  346.0000
## 23      PHO       C  432.0000
## 24      POR       C  425.0000
## 25      SAC       C  520.0000
## 26      TOR       C  257.7500
## 27      UTA       C  686.0000
## 28      WAS       C  525.6667
## 29      ATL      PF  592.0000
## 30      BOS      PF  527.0000
## 31      BRO      PF  280.2000
## 32      CHA      PF  288.3333
## 33      CHI      PF  732.7500
## 34      CLE      PF  964.5000
## 35      DAL      PF  624.0000
## 36      DEN      PF  473.6667
## 37      DET      PF  536.3333
## 38      GSW      PF  589.5000
## 39      HOU      PF  613.0000
## 40      IND      PF  476.0000
## 41      LAC      PF  554.2500
## 42      LAL      PF  507.6667
## 43      MEM      PF  310.4000
## 44      MIA      PF  368.2500
## 45      MIL      PF  263.0000
## 46      MIN      PF  184.2000
## 47      NOR      PF  943.0000
## 48      NYK      PF  259.0000
## 49      OKL      PF  463.6667
## 50      ORL      PF  320.0000
## 51      PHI      PF  265.5000
## 52      PHO      PF  669.7500
## 53      POR      PF  842.5000
## 54      SAC      PF  298.1667
## 55      SAN      PF  511.3333
## 56      TOR      PF  541.5000
## 57      UTA      PF  442.5000
## 58      WAS      PF  507.6667
## 59      ATL      PG  743.0000
## 60      BOS      PG  718.0000
## 61      BRO      PG  641.3333
## 62      CHA      PG  640.0000
## 63      CHI      PG  929.0000
## 64      CLE      PG  818.5000
## 65      DAL      PG  490.2500
## 66      DEN      PG  604.0000
## 67      DET      PG  498.0000
## 68      GSW      PG 1180.5000
## 69      HOU      PG  421.0000
## 70      IND      PG  637.7500
## 71      LAC      PG  497.5000
## 72      LAL      PG  452.0000
## 73      MEM      PG  435.5000
## 74      MIA      PG  364.6667
## 75      MIL      PG  371.2000
## 76      MIN      PG  417.2500
## 77      NOR      PG  240.3333
## 78      NYK      PG  454.7500
## 79      OKL      PG  931.3333
## 80      ORL      PG  459.5000
## 81      PHI      PG  272.0000
## 82      PHO      PG  644.5000
## 83      POR      PG  709.0000
## 84      SAC      PG  397.7500
## 85      SAN      PG  620.6667
## 86      TOR      PG 1009.5000
## 87      UTA      PG  475.6667
## 88      WAS      PG  603.0000
## 89      ATL      SF  506.0000
## 90      BOS      SF  256.0000
## 91      BRO      SF  590.6667
## 92      CHA      SF  362.5000
## 93      CHI      SF  379.6667
## 94      CLE      SF  592.7500
## 95      DAL      SF  492.7500
## 96      DEN      SF  909.5000
## 97      DET      SF  317.7500
## 98      GSW      SF  874.0000
## 99      HOU      SF  549.5000
## 100     IND      SF  353.5000
## 101     LAC      SF  498.0000
## 102     LAL      SF  445.3333
## 103     MEM      SF 1168.0000
## 104     MIA      SF  502.3333
## 105     MIL      SF  681.5000
## 106     MIN      SF  389.0000
## 107     NOR      SF  209.5000
## 108     NYK      SF  443.2000
## 109     OKL      SF  354.0000
## 110     ORL      SF  661.0000
## 111     PHI      SF  517.7500
## 112     PHO      SF  479.0000
## 113     POR      SF  374.6667
## 114     SAC      SF 1012.5000
## 115     SAN      SF  547.0000
## 116     TOR      SF  408.5000
## 117     UTA      SF  428.4000
## 118     WAS      SF  401.0000
## 119     ATL      SG  428.5000
## 120     BOS      SG  442.0000
## 121     BRO      SG  516.5000
## 122     CHA      SG  475.0000
## 123     CHI      SG  609.0000
## 124     CLE      SG  443.2500
## 125     DAL      SG 1513.0000
## 126     DEN      SG  216.0000
## 127     DET      SG  853.0000
## 128     GSW      SG  514.1667
## 129     HOU      SG  735.3333
## 130     IND      SG  942.0000
## 131     LAC      SG  371.0000
## 132     LAL      SG  420.2500
## 133     MEM      SG  407.4000
## 134     MIA      SG  500.3333
## 135     MIL      SG  784.6667
## 136     MIN      SG  730.0000
## 137     NOR      SG  722.6667
## 138     NYK      SG  447.0000
## 139     OKL      SG  563.2500
## 140     ORL      SG  536.4000
## 141     PHI      SG  326.2500
## 142     PHO      SG  314.6000
## 143     POR      SG  645.7500
## 144     SAC      SG  657.5000
## 145     SAN      SG  581.5000
## 146     TOR      SG  830.6667
## 147     UTA      SG  270.0000
## 148     WAS      SG  393.0000

類似apply家族的函數:aggregate()-2

aggregate(formula, data=資料, FUN=函數功能)

Formula: if you need all, put [.] into the formula (.~Team+Position)

aggregate(TotalPoints ~ Team+Position, 
          data = NBA1415, mean)
##     Team Position TotalPoints
## 1    BOS        C    744.5000
## 2    BRO        C    687.0000
## 3    CHA        C    618.6667
## 4    CHI        C    255.0000
## 5    CLE        C    271.5000
## 6    DAL        C    352.3333
## 7    DEN        C    489.0000
## 8    DET        C    608.5000
## 9    GSW        C    214.3333
## 10   HOU        C    339.0000
## 11   IND        C    532.5000
## 12   LAC        C    946.0000
## 13   LAL        C    307.0000
## 14   MEM        C    916.0000
## 15   MIA        C    442.0000
## 16   MIL        C    391.7500
## 17   MIN        C    264.6000
## 18   NOR        C    366.0000
## 19   NYK        C    388.0000
## 20   OKL        C    850.0000
## 21   ORL        C    822.0000
## 22   PHI        C    346.0000
## 23   PHO        C    432.0000
## 24   POR        C    425.0000
## 25   SAC        C    520.0000
## 26   TOR        C    257.7500
## 27   UTA        C    686.0000
## 28   WAS        C    525.6667
## 29   ATL       PF    592.0000
## 30   BOS       PF    527.0000
## 31   BRO       PF    280.2000
## 32   CHA       PF    288.3333
## 33   CHI       PF    732.7500
## 34   CLE       PF    964.5000
## 35   DAL       PF    624.0000
## 36   DEN       PF    473.6667
## 37   DET       PF    536.3333
## 38   GSW       PF    589.5000
## 39   HOU       PF    613.0000
## 40   IND       PF    476.0000
## 41   LAC       PF    554.2500
## 42   LAL       PF    507.6667
## 43   MEM       PF    310.4000
## 44   MIA       PF    368.2500
## 45   MIL       PF    263.0000
## 46   MIN       PF    184.2000
## 47   NOR       PF    943.0000
## 48   NYK       PF    259.0000
## 49   OKL       PF    463.6667
## 50   ORL       PF    320.0000
## 51   PHI       PF    265.5000
## 52   PHO       PF    669.7500
## 53   POR       PF    842.5000
## 54   SAC       PF    298.1667
## 55   SAN       PF    511.3333
## 56   TOR       PF    541.5000
## 57   UTA       PF    442.5000
## 58   WAS       PF    507.6667
## 59   ATL       PG    743.0000
## 60   BOS       PG    718.0000
## 61   BRO       PG    641.3333
## 62   CHA       PG    640.0000
## 63   CHI       PG    929.0000
## 64   CLE       PG    818.5000
## 65   DAL       PG    490.2500
## 66   DEN       PG    604.0000
## 67   DET       PG    498.0000
## 68   GSW       PG   1180.5000
## 69   HOU       PG    421.0000
## 70   IND       PG    637.7500
## 71   LAC       PG    497.5000
## 72   LAL       PG    452.0000
## 73   MEM       PG    435.5000
## 74   MIA       PG    364.6667
## 75   MIL       PG    371.2000
## 76   MIN       PG    417.2500
## 77   NOR       PG    240.3333
## 78   NYK       PG    454.7500
## 79   OKL       PG    931.3333
## 80   ORL       PG    459.5000
## 81   PHI       PG    272.0000
## 82   PHO       PG    644.5000
## 83   POR       PG    709.0000
## 84   SAC       PG    397.7500
## 85   SAN       PG    620.6667
## 86   TOR       PG   1009.5000
## 87   UTA       PG    475.6667
## 88   WAS       PG    603.0000
## 89   ATL       SF    506.0000
## 90   BOS       SF    256.0000
## 91   BRO       SF    590.6667
## 92   CHA       SF    362.5000
## 93   CHI       SF    379.6667
## 94   CLE       SF    592.7500
## 95   DAL       SF    492.7500
## 96   DEN       SF    909.5000
## 97   DET       SF    317.7500
## 98   GSW       SF    874.0000
## 99   HOU       SF    549.5000
## 100  IND       SF    353.5000
## 101  LAC       SF    498.0000
## 102  LAL       SF    445.3333
## 103  MEM       SF   1168.0000
## 104  MIA       SF    502.3333
## 105  MIL       SF    681.5000
## 106  MIN       SF    389.0000
## 107  NOR       SF    209.5000
## 108  NYK       SF    443.2000
## 109  OKL       SF    354.0000
## 110  ORL       SF    661.0000
## 111  PHI       SF    517.7500
## 112  PHO       SF    479.0000
## 113  POR       SF    374.6667
## 114  SAC       SF   1012.5000
## 115  SAN       SF    547.0000
## 116  TOR       SF    408.5000
## 117  UTA       SF    428.4000
## 118  WAS       SF    401.0000
## 119  ATL       SG    428.5000
## 120  BOS       SG    442.0000
## 121  BRO       SG    516.5000
## 122  CHA       SG    475.0000
## 123  CHI       SG    609.0000
## 124  CLE       SG    443.2500
## 125  DAL       SG   1513.0000
## 126  DEN       SG    216.0000
## 127  DET       SG    853.0000
## 128  GSW       SG    514.1667
## 129  HOU       SG    735.3333
## 130  IND       SG    942.0000
## 131  LAC       SG    371.0000
## 132  LAL       SG    420.2500
## 133  MEM       SG    407.4000
## 134  MIA       SG    500.3333
## 135  MIL       SG    784.6667
## 136  MIN       SG    730.0000
## 137  NOR       SG    722.6667
## 138  NYK       SG    447.0000
## 139  OKL       SG    563.2500
## 140  ORL       SG    536.4000
## 141  PHI       SG    326.2500
## 142  PHO       SG    314.6000
## 143  POR       SG    645.7500
## 144  SAC       SG    657.5000
## 145  SAN       SG    581.5000
## 146  TOR       SG    830.6667
## 147  UTA       SG    270.0000
## 148  WAS       SG    393.0000

Missing Value

計算平均的時候,該不該跳過缺值

x<-c(1,2,3,4,5,NA)
mean(x)
## [1] NA
mean(x, na.rm=T)
## [1] 3
sum(x)
## [1] NA
sum(x, na.rm=T)
## [1] 15

Removing NA

Subset

x <- c(1, 2, NA, 4, NA, 5)
x[! is.na(x)]
## [1] 1 2 4 5
complete.cases(x) #可使用在data frame,取出所有欄位都不是NA的row
## [1]  TRUE  TRUE FALSE  TRUE FALSE  TRUE

問題?????

R Markdown

R Markdown

  • http://rmarkdown.rstudio.com/
  • R + Markdown
    • R Markdown—knitr—>Markdown
    • Markdown—markdown—>HTML
  • 用來撰寫可以重複執行/動態的 R語言執行報告
  • 報告格式:Slides, PDF, HTML. Word,…
  • 又要交作業了….

R Markdown 元件

  • 基於Markdown文件
  • 所有寫在R Code Chunks的R程式碼都會執行,並將結果輸出
  • 放上GitHub的文件,會輸出成.md檔

Step 1 開啟新的R Markdown 檔案

如果跳出是否要安裝Packages,選

Step 2 設定輸出格式

最後要放上GitHub,所以選From Template裡的GitHub Document

Step 3 設定文件基本資訊

程式會產生內建的參考範例,先按“Knit”試試

自動生成的.md檔案在GitHub上的樣子

R Code Chunk的參數

  • eval:要不要執行並顯示在輸出的Markdown檔案內
  • echo:要不要一起顯示程式碼以及執行結果
  • warning, error, message:要不要顯示錯誤訊息
  • cache:是否要暫存結果

Homework 3

分析NBA 2014到2015球季

  • 各隊最辛苦的球員(出戰分鐘數TotalMinutesPlayed 最多)
  • 各隊得分王(TotalPoints最多)
  • 各隊最有效率的球員(總得分/出戰分鐘數 最高)
  • 各隊三分球出手最準的球員(ThreesMade/ThreesAttempted 最高)

Homework 3 詳細要求與配分1

  • Title: NBA 2014-2015球季 各隊分析 (5 pt)
  • 把資料讀進來的程式碼 (5 pt)
  • 次標題1:各隊最辛苦的球員 (20 pt)
    • 標題 (2),說明 (3),程式碼 (5) 和結果 (10)
    • 結果要包括隊名 (2) 與球員姓名 (3) 與總出場數 (3),按照總出場數排序(大到小) (2)

Homework 3 詳細要求與配分2

  • 次標題2:各隊得分王 (20 pt)
    • 程式碼和結果,輸出要包括隊名與球員姓名與總分,按照總分排序
  • 次標題3:各隊最有效率的球員 (25 pt)
    • 程式碼和結果,輸出要包括隊名與球員姓名與效率計算結果 (8),按照效率計算結果排序
  • 次標題4:各隊三分球出手最準的球員 (25 pt)
    • 程式碼和結果,輸出要包括隊名與球員姓名與三分球命中率 (8),按照三分球命中率排序

作業範例 — R Markdown

作業範例 — Markdown@GitHub

作業繳交

問題???????????

R Function

函數 Function

  • 將程式碼依功能要求,寫成可重複使用的『函數』
    • mean()
    • sum()
  • 好處:
    • 程式碼變短,閱讀和偵錯容易
    • 功能可以重複使用,節省開發時間

定義一個新的函數

函數名稱<-function(參數1, 參數2, ….)({程式碼們}

四捨五入到小數點第二位

round2<-function(vector){
    round(vector,digits = 2)
}
round2(3.886)
## [1] 3.89

Lazy Evaluation

沒用到Nothing參數,程式也不會出錯

round2Lazy<-function(vector,nothing){
    round(vector,digits = 2)
}
round2(3.886)
## [1] 3.89

Lazy Evaluation 2

  • 使用f參數時,沒有輸入b,但R也不會檢查
  • 在執行print(b)時才會跳出錯誤訊息
f <- function(a, b) {
        print(a)
        print(b)
}
f(45)
## [1] 45
## Error in print(b): argument "b" is missing, with no default

…參數

  • 意指引用其他函數的參數
  • apply(Data, MARGIN, FUN,…)
  • 例:平均再取四捨五入
roundmean<-function(vector, ...){
    round(mean(vector, ...),digits=2)
}
roundmean(c(1.1,2,3,4,5))
## [1] 3.02
roundmean(c(1.1,2,3,4,5,NA))
## [1] NA
roundmean(c(1.1,2,3,4,5,NA),na.rm=T)
## [1] 3.02

…參數 2

roundmean<-function(vector, ...){
    round(mean(vector, ...),digits=2)
}
roundmean(c(1.1,2,3,4,5))
## [1] 3.02
roundmean(c(1.1,2,3,4,5,NA))
## [1] NA
roundmean(c(1.1,2,3,4,5,NA),na.rm=T)
## [1] 3.02

參數預設值

使用者如果沒有指定參數值,直接帶入預設

roundDe<-function(v=1.111:10.111){
    round(v,digits = 2)
}
roundDe(1.66:6.66)
## [1] 1.66 2.66 3.66 4.66 5.66 6.66
roundDe()
##  [1]  1.11  2.11  3.11  4.11  5.11  6.11  7.11  8.11  9.11 10.11

retrun()

停止函數執行,並回傳值

round2<-function(v){
    if(!is.numeric(v)){
        print("輸入數字")
        return()
    }
    round(v,digits = 2)
}
round2("a")
## [1] "輸入數字"
## NULL

函數也可以當作參數來用

apply(Data, MARGIN, FUN,…)

apply(iris,2,max)
## Sepal.Length  Sepal.Width Petal.Length  Petal.Width      Species 
##        "7.9"        "4.4"        "6.9"        "2.5"  "virginica"
RoundNumber2<-function(v,XFun){
    round(XFun(v),digits = 2)
}
RoundNumber2(1.1:10.1,mean)
## [1] 5.6

問題???????????

Getting Data

What is 'Data'

Getting Data

學會:

  • 找資料、抓資料、總之就是弄到資料
  • 資料前處理原則:tidy
  • 用R做到以上工作

Raw data -> Processing script -> Tidy data -> Data analysis -> Data communication

課堂上玩得很開心的資料 Tidy Data

  • 一個欄位(Column)內只有一個數值,最好要有凡人看得懂的Column Name
  • 不同的觀察值應該要在不同行(Raw)
  • 一張表裡面,有所有分析需要的資料
  • 如果一定要多張表,中間一定要有index可以把表串起來
  • One file, one table
NBA1415
##     League             Name Team Position GamesPlayed TotalMinutesPlayed
## 1      NBA       Quincy Acy  NYK       SF          68               1288
## 2      NBA     Jordan Adams  MEM       SG          30                249
## 3      NBA     Steven Adams  OKL        C          70               1776
## 4      NBA      Jeff Adrien  MIN       PF          17                215
## 5      NBA    Arron Afflalo  POR       SG          78               2502
## 6      NBA    Alexis Ajinca  NOR        C          68                956
## 7      NBA   Furkan Aldemir  PHI       PF          41                541
## 8      NBA     Cole Aldrich  NYK        C          61                979
## 9      NBA Lamarcu Aldridge  POR       PF          71               2514
## 10     NBA      Lavoy Allen  IND       PF          63               1066
## 11     NBA       Tony Allen  MEM       SG          63               1647
## 12     NBA  Al-farouq Aminu  DAL       SF          74               1368
## 13     NBA     Lou Amundson  NYK       PF          53                937
## 14     NBA   Chris Andersen  MIA        C          60               1131
## 15     NBA    Alan Anderson  BRO       SG          74               1743
## 16     NBA    Kyle Anderson  SAN       SG          33                355
## 17     NBA    Ryan Anderson  NOR       PF          61               1677
## 18     NBA  G Antetokounmpo  MIL       SG          81               2542
## 19     NBA  Carmelo Anthony  NYK       SF          40               1430
## 20     NBA     Joel Anthony  DET        C          49                408
## 21     NBA       Pero Antic  ATL       PF          63               1041
## 22     NBA     Trevor Ariza  HOU       SG          82               2936
## 23     NBA   Darrell Arthur  DEN       PF          58                986
## 24     NBA        Omer Asik  NOR        C          77               1979
## 25     NBA    D.j. Augustin  OKL       PG          82               1964
## 26     NBA       Jeff Ayres  SAN       PF          51                386
## 27     NBA     Luke Babbitt  NOR       SF          63                828
## 28     NBA Cameron Bairstow  CHI       PF          18                 67
## 29     NBA  Leandro Barbosa  GSW       SG          66                983
## 30     NBA       J.j. Barea  DAL       PG          77               1368
## 31     NBA  Andrea Bargnani  NYK        C          29                785
## 32     NBA  Harrison Barnes  GSW       SF          82               2317
## 33     NBA      Matt Barnes  LAC       SF          76               2276
## 34     NBA      Earl Barron  PHO       PF          16                143
## 35     NBA      Will Barton  DEN       SG          58                982
## 36     NBA     Brandon Bass  BOS       PF          82               1932
## 37     NBA    Nicolas Batum  POR       SF          71               2380
## 38     NBA   Jerryd Bayless  MIL       PG          77               1723
## 39     NBA      Aron Baynes  SAN       PF          70               1126
## 40     NBA    Kent Bazemore  ATL       SG          75               1327
## 41     NBA     Bradley Beal  WAS       SG          63               2109
## 42     NBA  Michael Beasley  MIA       PF          24                503
## 43     NBA  Marco Belinelli  SAN       SG          62               1386
## 44     NBA Jerrelle Benimon  UTA       PF           2                  3
## 45     NBA  Anthony Bennett  MIN       PF          57                898
## 46     NBA Patrick Beverley  HOU       PG          56               1729
## 47     NBA      Sim Bhullar  SAC        C           3                  3
## 48     NBA  Bismack Biyombo  CHA        C          64               1240
## 49     NBA      Tarik Black  LAL       PF          63               1195
## 50     NBA     Dejuan Blair  WAS        C          29                179
## 51     NBA      Steve Blake  POR       PG          81               1529
## 52     NBA     Eric Bledsoe  PHO       PG          81               2799
## 53     NBA      Vander Blue  LAL       SG           2                 74
## 54     NBA Bojan Bogdanovic  BRO       SF          78               1856
## 55     NBA     Andrew Bogut  GSW        C          67               1583
## 56     NBA      Matt Bonner  SAN       PF          72                938
## 57     NBA    Trevor Booker  UTA       PF          79               1562
## 58     NBA    Carlos Boozer  LAL       PF          71               1692
## 59     NBA       Chris Bosh  MIA       PF          44               1557
## 60     NBA    Avery Bradley  BOS       PG          77               2427
## 61     NBA      Elton Brand  ATL       PF          36                487
## 62     NBA     Corey Brewer  HOU       SF          80               2088
## 63     NBA     Aaron Brooks  CHI       PG          82               1885
## 64     NBA     Jabari Brown  LAL       SG          19                567
## 65     NBA    Lorenzo Brown  MIN       PG          29                550
## 66     NBA     Markel Brown  BRO       SG          47                784
## 67     NBA    Shannon Brown  MIA       PG           5                 89
## 68     NBA      Kobe Bryant  LAL       SG          35               1206
## 69     NBA   Chase Budinger  MIN       SF          67               1287
## 70     NBA   Reggie Bullock  PHO       SG          36                339
## 71     NBA       Trey Burke  UTA       PG          76               2286
## 72     NBA       Alec Burks  UTA       PG          27                899
## 73     NBA     Caron Butler  DET       SF          78               1626
## 74     NBA     Jimmy Butler  CHI       SG          65               2515
## 75     NBA    Rasual Butler  WAS       SF          75               1509
## 76     NBA    Dwight Buycks  LAL       PG           6                124
## 77     NBA       Will Bynum  WAS       PG           7                 67
## 78     NBA    Bruno Caboclo  TOR       SF           8                 24
## 79     NBA    Nick Calathes  MEM       SG          58                835
## 80     NBA    Jose Calderon  NYK       PG          42               1269
## 81     NBA Ke Caldwell-pope  DET       SG          82               2591
## 82     NBA    Isaiah Canaan  PHI       PG          48                940
## 83     NBA     Clint Capela  HOU        C          12                 90
## 84     NBA  Demarre Carroll  ATL       SF          71               2188
## 85     NBA     Vince Carter  MEM       SG          66               1092
## 86     NBA  Carter-williams  MIL       PG          67               2151
## 87     NBA      Omri Casspi  SAC       SF          67               1418
## 88     NBA   Mario Chalmers  MIA       PG          80               2368
## 89     NBA   Tyson Chandler  DAL        C          75               2286
## 90     NBA  Wilson Chandler  DEN       SF          78               2474
## 91     NBA      Will Cherry  CLE       PG           8                 70
## 92     NBA Patr Christopher  UTA       SG           4                 29
## 93     NBA       Earl Clark  BRO       PF           9                 83
## 94     NBA        Ian Clark  DEN       SG          30                193
## 95     NBA  Jordan Clarkson  LAL       PG          59               1474
## 96     NBA    Victor Claver  POR       PF          10                 75
## 97     NBA      Norris Cole  NOR       PG          75               1830
## 98     NBA  Darren Collison  SAC       PG          45               1562
## 99     NBA    Nick Collison  OKL       PF          66               1105
## 100    NBA      Mike Conley  MEM       PG          70               2225
## 101    NBA      Jack Cooley  UTA       SF          16                 86
## 102    NBA   Chris Copeland  IND       SF          50                829
## 103    NBA     Bryce Cotton  UTA       PG          16                162
## 104    NBA Demarcus Cousins  SAC        C          59               2013
## 105    NBA Robert Covington  PHI       SF          69               1930
## 106    NBA     Allen Crabbe  POR       SG          51                684
## 107    NBA   Jamal Crawford  LAC       SG          64               1706
## 108    NBA      Jae Crowder  BOS       SF          82               1654
## 109    NBA Dante Cunningham  NOR       PF          66               1650
## 110    NBA Jared Cunningham  LAC       SG          19                 91
## 111    NBA       Seth Curry  PHO       PG           2                  8
## 112    NBA    Stephen Curry  GSW       PG          80               2613
## 113    NBA Samuel Dalembert  NYK        C          32                544
## 114    NBA     Troy Daniels  CHA       SG          47                401
## 115    NBA     Luigi Datome  BOS       SF          21                211
## 116    NBA   Brandon Davies  BRO       PF          27                424
## 117    NBA    Anthony Davis  NOR       PF          68               2460
## 118    NBA         Ed Davis  LAL       PF          79               1842
## 119    NBA       Glen Davis  LAC       PF          74                909
## 120    NBA    Andre Dawkins  MIA       SG           4                 22
## 121    NBA      Austin Daye  ATL       SF          35                348
## 122    NBA   Dewayne Dedmon  ORL        C          59                849
## 123    NBA Matt Dellavedova  CLE       SG          67               1378
## 124    NBA        Luol Deng  MIA       SF          72               2420
## 125    NBA    Demar Derozan  TOR       SG          60               2102
## 126    NBA       Boris Diaw  SAN       PF          81               1987
## 127    NBA     Gorgui Dieng  MIN        C          73               2193
## 128    NBA Spence Dinwiddie  DET       PG          34                458
## 129    NBA      Joey Dorsey  HOU       PF          69                856
## 130    NBA    Toney Douglas  NOR       PG          12                177
## 131    NBA  Douglas-roberts  LAC       SG          12                103
## 132    NBA     Goran Dragic  MIA       SG          78               2641
## 133    NBA     Zoran Dragic  MIA       SG          16                 76
## 134    NBA       Larry Drew  PHI       PG          12                220
## 135    NBA   Andre Drummond  DET        C          82               2497
## 136    NBA     Jared Dudley  MIL       SG          72               1716
## 137    NBA       Tim Duncan  SAN       PF          77               2224
## 138    NBA    Mike Dunleavy  CHI       SF          63               1837
## 139    NBA     Kevin Durant  OKL       SF          27                914
## 140    NBA Cleanthony Early  NYK       SF          39                651
## 141    NBA  Wayne Ellington  LAL       SG          65               1676
## 142    NBA      Monta Ellis  DAL       SG          80               2698
## 143    NBA      James Ennis  MIA       SF          62               1052
## 144    NBA      Tyler Ennis  MIL       PG          33                413
## 145    NBA     Jeremy Evans  UTA       SF          38                266
## 146    NBA     Reggie Evans  SAC       PF          47                767
## 147    NBA     Tyreke Evans  NOR       SG          79               2695
## 148    NBA       Dante Exum  UTA       SG          82               1821
## 149    NBA     Festus Ezeli  GSW        C          46                504
## 150    NBA   Kenneth Faried  DEN       PF          75               2085
## 151    NBA    Jordan Farmar  LAC       PG          36                528
## 152    NBA   Derrick Favors  UTA       PF          74               2281
## 153    NBA   Raymond Felton  DAL       PG          29                281
## 154    NBA    Landry Fields  TOR       SG          26                217
## 155    NBA    Evan Fournier  ORL       SG          58               1659
## 156    NBA       Randy Foye  DEN       SG          51               1089
## 157    NBA  Jamaal Franklin  DEN       SG           3                 14
## 158    NBA      Tim Frazier  POR       PG          11                241
## 159    NBA  Jimmer Fredette  NOR       PG          50                514
## 160    NBA    Joel Freeland  POR        C          48                618
## 161    NBA    Channing Frye  ORL       PF          75               1867
## 162    NBA Danilo Gallinari  DEN       SF          59               1421
## 163    NBA Langsto Galloway  NYK       PG          45               1459
## 164    NBA Francisco Garcia  HOU       SG          14                201
## 165    NBA    Kevin Garnett  MIN       PF          47                948
## 166    NBA       Marc Gasol  MEM        C          81               2690
## 167    NBA        Pau Gasol  CHI       PF          78               2682
## 168    NBA         Rudy Gay  SAC       SF          68               2412
## 169    NBA       Alonzo Gee  POR       SF          54                664
## 170    NBA      Paul George  IND       SF           6                 92
## 171    NBA       Taj Gibson  CHI       PF          62               1694
## 172    NBA    Manu Ginobili  SAN       SG          70               1591
## 173    NBA      Rudy Gobert  UTA        C          82               2163
## 174    NBA      Drew Gooden  WAS       PF          51                866
## 175    NBA   Archie Goodwin  PHO       SG          41                535
## 176    NBA     Aaron Gordon  ORL       PF          47                797
## 177    NBA       Ben Gordon  ORL       SG          56                789
## 178    NBA      Drew Gordon  PHI       PF           9                 72
## 179    NBA      Eric Gordon  NOR       SG          61               2020
## 180    NBA    Marcin Gortat  WAS        C          82               2455
## 181    NBA    Danny Granger  MIA       SF          31                611
## 182    NBA     Jerami Grant  PHI       SF          65               1380
## 183    NBA      Danny Green  SAN       SG          81               2311
## 184    NBA   Draymond Green  GSW       SF          79               2487
## 185    NBA      Erick Green  DEN       PG          43                414
## 186    NBA     Gerald Green  PHO       SG          74               1447
## 187    NBA   Jamychal Green  MEM       PF          24                165
## 188    NBA       Jeff Green  MEM       SF          78               2459
## 189    NBA     Willie Green  ORL       SG          52                953
## 190    NBA    Blake Griffin  LAC       PF          67               2354
## 191    NBA  Jorge Gutierrez  MIL       PG          20                176
## 192    NBA    P.j. Hairston  CHA       SG          45                690
## 193    NBA  Jordan Hamilton  LAC       SG          14                123
## 194    NBA  Justin Hamilton  MIN        C          41                709
## 195    NBA Tyler Hansbrough  TOR       PF          74               1057
## 196    NBA     Tim Hardaway  NYK       SG          70               1683
## 197    NBA     James Harden  HOU       SG          81               2979
## 198    NBA Maurice Harkless  ORL       SF          45                674
## 199    NBA     Devin Harris  DAL       PG          76               1686
## 200    NBA      Gary Harris  DEN       SG          55                724
## 201    NBA       Joe Harris  CLE       SG          50                491
## 202    NBA    Tobias Harris  ORL       SF          68               2367
## 203    NBA    Udonis Haslem  MIA       PF          62               1000
## 204    NBA    Spencer Hawes  LAC       PF          73               1276
## 205    NBA      Chuck Hayes  TOR        C          29                255
## 206    NBA   Gordon Hayward  UTA       SF          76               2618
## 207    NBA  Brendan Haywood  CLE        C          22                120
## 208    NBA Gerald Henderson  CHA       SG          80               2323
## 209    NBA     Xavier Henry  LAL       SF           9                 83
## 210    NBA      John Henson  MIL        C          67               1233
## 211    NBA      Roy Hibbert  IND        C          76               1930
## 212    NBA     J.j. Hickson  DEN        C          73               1415
## 213    NBA     Nene Hilario  WAS       PF          68               1696
## 214    NBA      George Hill  IND       PG          43               1266
## 215    NBA      Jordan Hill  LAL       PF          70               1877
## 216    NBA     Solomon Hill  IND       SF          82               2380
## 217    NBA     Kirk Hinrich  CHI       SG          66               1611
## 218    NBA     Jrue Holiday  NOR       PG          40               1301
## 219    NBA   Justin Holiday  GSW       SG          59                658
## 220    NBA     Ryan Hollins  SAC        C          46                444
## 221    NBA      Rodney Hood  UTA       SG          50               1070
## 222    NBA       Al Horford  ATL       PF          76               2318
## 223    NBA    Dwight Howard  HOU        C          41               1224
## 224    NBA    Lester Hudson  LAC       SG           5                 56
## 225    NBA    Robbie Hummel  MIN       SF          45                744
## 226    NBA   Kris Humphries  WAS       PF          64               1346
## 227    NBA      Serge Ibaka  OKL       PF          64               2119
## 228    NBA   Andre Iguodala  GSW       SG          77               2066
## 229    NBA   Ersan Ilyasova  MIL       PF          58               1319
## 230    NBA       Joe Ingles  UTA       SF          79               1673
## 231    NBA     Kyrie Irving  CLE       PG          75               2735
## 232    NBA     Jarrett Jack  BRO       PG          80               2243
## 233    NBA   Reggie Jackson  DET       PG          77               2269
## 234    NBA    Bernard James  DAL        C          16                156
## 235    NBA     Lebron James  CLE       SF          69               2497
## 236    NBA     Al Jefferson  CHA        C          65               1991
## 237    NBA   Cory Jefferson  BRO       PF          50                535
## 238    NBA Richar Jefferson  DAL       SF          74               1248
## 239    NBA     John Jenkins  ATL       SG          24                297
## 240    NBA Brandon Jennings  DET       PG          41               1172
## 241    NBA    Jonas Jerebko  BOS       PF          75               1231
## 242    NBA    Grant Jerrett  UTA       PF           8                 53
## 243    NBA     Amir Johnson  TOR       PF          75               1979
## 244    NBA    Chris Johnson  UTA       SF          29                526
## 245    NBA    James Johnson  TOR       PF          70               1368
## 246    NBA      Joe Johnson  BRO       SG          80               2787
## 247    NBA     Nick Johnson  HOU       SG          28                262
## 248    NBA    Tyler Johnson  MIA       SG          32                600
## 249    NBA   Wesley Johnson  LAL       SF          76               2244
## 250    NBA    Dahntay Jones  LAC       PG          33                130
## 251    NBA      James Jones  CLE       SF          57                652
## 252    NBA      Perry Jones  OKL       SF          43                633
## 253    NBA   Terrence Jones  HOU       PF          33                887
## 254    NBA   Deandre Jordan  LAC        C          82               2819
## 255    NBA    Jerome Jordan  BRO        C          44                381
## 256    NBA      Cory Joseph  SAN       PG          79               1445
## 257    NBA      Chris Kaman  POR        C          74               1400
## 258    NBA      Enes Kanter  OKL        C          75               2139
## 259    NBA   Sergey Karasev  BRO       SG          33                558
## 260    NBA       Ryan Kelly  LAL       PF          52               1232
## 261    NBA M Kidd-gilchrist  CHA       SF          55               1588
## 262    NBA  Sean Kilpatrick  MIN       SG           4                 71
## 263    NBA Andrei Kirilenko  BRO       SF           7                 37
## 264    NBA        Alex Kirk  CLE        C           5                 15
## 265    NBA   Brandon Knight  PHO       PG          63               2040
## 266    NBA      Kyle Korver  ATL       SG          75               2418
## 267    NBA     Kosta Koufos  MEM        C          81               1350
## 268    NBA    Ognjen Kuzmic  GSW        C          16                 72
## 269    NBA      Jeremy Lamb  OKL       SG          47                635
## 270    NBA      Carl Landry  SAC       PF          70               1195
## 271    NBA     Shane Larkin  NYK       PG          76               1864
## 272    NBA Joffre Lauvergne  DEN       PF          24                267
## 273    NBA      Zach Lavine  MIN       PG          77               1906
## 274    NBA        Ty Lawson  DEN       PG          75               2668
## 275    NBA       Ricky Ledo  NYK       SG          17                245
## 276    NBA     Courtney Lee  MEM       SG          77               2355
## 277    NBA        David Lee  GSW       PF          49                904
## 278    NBA      Malcolm Lee  PHI       SG           1                  2
## 279    NBA         Alex Len  PHO        C          69               1518
## 280    NBA    Kawhi Leonard  SAN       SF          64               2031
## 281    NBA   Meyers Leonard  POR        C          55                850
## 282    NBA        Jon Leuer  MEM       PF          63                826
## 283    NBA   Damian Lillard  POR       PG          82               2928
## 284    NBA       Jeremy Lin  LAL       PG          74               1910
## 285    NBA Shaun Livingston  GSW       PG          78               1469
## 286    NBA      Brook Lopez  BRO        C          72               2104
## 287    NBA      Robin Lopez  POR        C          59               1638
## 288    NBA       Kevin Love  CLE       PF          76               2562
## 289    NBA       Kyle Lowry  TOR       PG          70               2422
## 290    NBA       John Lucas  DET       PG          21                273
## 291    NBA      Kalin Lucas  MEM       PG           1                  6
## 292    NBA     Shelvin Mack  ATL       PG          55                832
## 293    NBA      Ian Mahinmi  IND        C          61               1146
## 294    NBA     Devyn Marble  ORL       SG          16                212
## 295    NBA     Shawn Marion  CLE       SF          58               1108
## 296    NBA Kendall Marshall  MIL       PG          28                416
## 297    NBA   Cartier Martin  DET       SF          23                200
## 298    NBA    Kenyon Martin  MIL       PF          11                106
## 299    NBA     Kevin Martin  MIN       SG          39               1303
## 300    NBA  Wesley Matthews  POR       SG          60               2027
## 301    NBA    Jason Maxiell  CHA       PF          61                880
## 302    NBA        O.j. Mayo  MIL       SG          71               1696
## 303    NBA Luc Mbah_a_moute  PHI       SF          67               1916
## 304    NBA     James Mcadoo  GSW       SG          15                140
## 305    NBA     Ray Mccallum  SAC       PG          68               1434
## 306    NBA    C.j. Mccollum  POR       SG          62                973
## 307    NBA   K.j. Mcdaniels  HOU       SG          62               1353
## 308    NBA   Doug Mcdermott  CHI       SF          36                320
## 309    NBA     Mitch Mcgary  OKL       PF          32                485
## 310    NBA     Javale Mcgee  PHI        C          23                256
## 311    NBA     Ben Mclemore  SAC       SG          82               2674
## 312    NBA     Jerel Mcneal  PHO       SG           6                 36
## 313    NBA   Josh Mcroberts  MIA       PF          17                297
## 314    NBA      Jodie Meeks  DET       SG          60               1463
## 315    NBA        Gal Mekel  NOR       PG           4                 44
## 316    NBA  Khris Middleton  MIL       SF          79               2378
## 317    NBA       C.j. Miles  IND       SG          70               1843
## 318    NBA     Andre Miller  SAC       PG          81               1252
## 319    NBA    Darius Miller  NOR       SF           5                 44
## 320    NBA      Mike Miller  CLE       SF          52                698
## 321    NBA    Quincy Miller  DET       PF          10                120
## 322    NBA      Patty Mills  SAN       PG          51                799
## 323    NBA   Elijah Millsap  UTA       SG          47                924
## 324    NBA     Paul Millsap  ATL       PF          73               2390
## 325    NBA   Nikola Mirotic  CHI       PF          82               1658
## 326    NBA    Nazr Mohammed  CHI        C          23                131
## 327    NBA      Greg Monroe  DET       PF          69               2138
## 328    NBA    E'twaun Moore  CHI       SG          56                507
## 329    NBA    Eric Moreland  SAC       PF           3                  3
## 330    NBA    Darius Morris  BRO       PG          37                295
## 331    NBA    Marcus Morris  PHO       PF          81               2046
## 332    NBA  Markieff Morris  PHO       PF          82               2581
## 333    NBA   Anthony Morrow  OKL       SG          74               1808
## 334    NBA Donat Motiejunas  HOU       PF          71               2040
## 335    NBA   Timofey Mozgov  CLE        C          81               2058
## 336    NBA Shabazz Muhammad  MIN       SF          38                867
## 337    NBA     Toure' Murry  WAS       SF           5                 19
## 338    NBA     Mike Muscala  ATL       PF          40                503
## 339    NBA   Shabazz Napier  MIA       PG          51               1014
## 340    NBA        Gary Neal  MIN       PG          54               1193
## 341    NBA    Jameer Nelson  DEN       PG          63               1403
## 342    NBA Andrew Nicholson  ORL       PF          40                491
## 343    NBA      Joakim Noah  CHI        C          67               2047
## 344    NBA     Nerlens Noel  PHI       PF          75               2311
## 345    NBA   Lucas Nogueira  TOR        C           4                 13
## 346    NBA      Steve Novak  OKL       SF          35                204
## 347    NBA    Dirk Nowitzki  DAL       PF          77               2285
## 348    NBA     Jusuf Nurkic  DEN        C          62               1105
## 349    NBA  Johnny O'bryant  MIL       PF          34                365
## 350    NBA     Kyle O'quinn  ORL       PF          51                825
## 351    NBA   Victor Oladipo  ORL       SG          72               2572
## 352    NBA     Kelly Olynyk  BOS        C          64               1424
## 353    NBA    Arinze Onuaku  MIN       PF           6                 70
## 354    NBA    Zaza Pachulia  MIL        C          73               1730
## 355    NBA Kos Papanikolaou  HOU       SF          43                796
## 356    NBA    Jannero Pargo  CHA       PG           9                 74
## 357    NBA    Jabari Parker  MIL       SF          25                738
## 358    NBA      Tony Parker  SAN       PG          68               1957
## 359    NBA Chandler Parsons  DAL       SF          66               2186
## 360    NBA Patric Patterson  TOR       PF          81               2160
## 361    NBA       Chris Paul  LAC       PG          82               2860
## 362    NBA    Adreian Payne  MIN       PF          32                741
## 363    NBA    Elfrid Payton  ORL       PG          82               2490
## 364    NBA   Nikola Pekovic  MIN        C          31                817
## 365    NBA Kendrick Perkins  DAL        C          68               1147
## 366    NBA      Paul Pierce  WAS       SF          73               1913
## 367    NBA    Mason Plumlee  BRO       PF          82               1739
## 368    NBA    Miles Plumlee  MIL        C          73               1195
## 369    NBA Quincy Pondexter  NOR       SF          75               1792
## 370    NBA      Otto Porter  WAS       SF          74               1438
## 371    NBA    Dwight Powell  DAL       SF          29                237
## 372    NBA     Phil Pressey  BOS       PG          50                601
## 373    NBA       A.j. Price  PHO       PG          25                312
## 374    NBA     Ronnie Price  LAL       PG          43                983
## 375    NBA   Pablo Prigioni  HOU       PG          67               1197
## 376    NBA  Tayshaun Prince  DET       SF          58               1397
## 377    NBA  Miros Raduljica  MIN        C           5                 24
## 378    NBA    Julius Randle  LAL       PF           1                 14
## 379    NBA Shavlik Randolph  BOS       PF          21                126
## 380    NBA    Zach Randolph  MEM       PF          71               2303
## 381    NBA      J.j. Redick  LAC       SG          78               2407
## 382    NBA        Glen Rice  WAS       SG           5                 42
## 383    NBA Jason Richardson  PHI       SG          19                417
## 384    NBA     Luke Ridnour  ORL       PG          47                683
## 385    NBA    Austin Rivers  LAC       SG          76               1561
## 386    NBA   Andre Roberson  OKL       SG          68               1283
## 387    NBA    Brian Roberts  CHA       PG          72               1332
## 388    NBA   Glenn Robinson  PHI       SF          35                264
## 389    NBA    Nate Robinson  LAC       PG          42                591
## 390    NBA  Thomas Robinson  PHI       PF          54                798
## 391    NBA      Rajon Rondo  DAL       PG          68               2019
## 392    NBA     Derrick Rose  CHI       PG          51               1531
## 393    NBA    Terrence Ross  TOR       SF          82               2095
## 394    NBA      Ricky Rubio  MIN       PG          22                692
## 395    NBA     Damjan Rudez  IND       SF          68               1050
## 396    NBA     Brandon Rush  GSW       SG          33                273
## 397    NBA     Robert Sacre  LAL        C          67               1128
## 398    NBA     John Salmons  NOR       SF          21                270
## 399    NBA   Jakarr Sampson  PHI       PF          74               1131
## 400    NBA    Larry Sanders  MIL        C          27                586
## 401    NBA  Dennis Schroder  ATL       PG          77               1514
## 402    NBA       Luis Scola  IND       PF          81               1659
## 403    NBA       Mike Scott  ATL       PF          68               1125
## 404    NBA  Thabo Sefolosha  ATL       SG          52                977
## 405    NBA   Kevin Seraphin  WAS        C          79               1235
## 406    NBA   Ramon Sessions  WAS       PG          64               1187
## 407    NBA    Iman Shumpert  CLE       SG          62               1526
## 408    NBA     Alexey Shved  NYK       PG          42                767
## 409    NBA       Henry Sims  PHI        C          73               1401
## 410    NBA     Kyle Singler  OKL       SF          80               1742
## 411    NBA     Donald Sloan  IND       PG          53               1113
## 412    NBA     Marcus Smart  BOS       PG          67               1810
## 413    NBA       Greg Smith  DAL       PF          42                362
## 414    NBA        Ish Smith  PHI       PG          55                835
## 415    NBA       J.r. Smith  CLE       SG          70               2086
## 416    NBA      Jason Smith  NYK        C          82               1786
## 417    NBA       Josh Smith  HOU       PF          83               2307
## 418    NBA       Russ Smith  MEM       PG          12                 66
## 419    NBA       Tony Snell  CHI       SF          72               1415
## 420    NBA Marrees Speights  GSW       PF          76               1204
## 421    NBA   Tiago Splitter  SAN       PF          52               1030
## 422    NBA     Nik Stauskas  SAC       SG          73               1130
## 423    NBA Lance Stephenson  CHA       SG          61               1574
## 424    NBA    Greg Stiemsma  TOR        C          17                 67
## 425    NBA   David Stockton  SAC       PG           3                 33
## 426    NBA   Jarnell Stokes  MEM       PF          19                126
## 427    NBA Amare Stoudemire  DAL       PF          59               1245
## 428    NBA   Rodney Stuckey  IND       PG          71               1878
## 429    NBA  Jared Sullinger  BOS       PF          58               1568
## 430    NBA      Jeff Taylor  CHA       SF          29                431
## 431    NBA      Jeff Teague  ATL       PG          73               2231
## 432    NBA  Mirza Teletovic  BRO       PF          40                894
## 433    NBA Sebastia Telfair  OKL       PG          16                327
## 434    NBA   Garrett Temple  WAS       SG          52                742
## 435    NBA      Jason Terry  HOU       SG          77               1641
## 436    NBA    Isaiah Thomas  BOS       PG          67               1726
## 437    NBA     Lance Thomas  NYK       SF          62               1491
## 438    NBA   Malcolm Thomas  PHI       PF          17                194
## 439    NBA     Tyrus Thomas  MEM       PF           2                  6
## 440    NBA  Hollis Thompson  PHI       SG          71               1776
## 441    NBA   Jason Thompson  SAC       PF          81               1991
## 442    NBA    Klay Thompson  GSW       SG          77               2457
## 443    NBA Tristan Thompson  CLE       PF          82               2188
## 444    NBA  Marcus Thornton  PHO       SG          48                721
## 445    NBA Anthony Tolliver  DET       PF          76               1434
## 446    NBA      P.j. Tucker  PHO       SF          78               2382
## 447    NBA     Ronny Turiaf  MIN        C           2                 20
## 448    NBA    Hedo Turkoglu  LAC       SF          62                705
## 449    NBA      Evan Turner  BOS       SG          82               2259
## 450    NBA        Ekpe Udoh  LAC       PF          33                131
## 451    NBA       Beno Udrih  MEM       PG          79               1494
## 452    NBA Jona Valanciunas  TOR        C          80               2098
## 453    NBA Anderson Varejao  CLE        C          26                637
## 454    NBA  Greivis Vasquez  TOR       PG          82               1990
## 455    NBA Charl Villanueva  DAL       PF          64                678
## 456    NBA      Noah Vonleh  CHA       PF          25                257
## 457    NBA   Nikola Vucevic  ORL        C          74               2528
## 458    NBA      Dwyane Wade  MIA       SG          62               1974
## 459    NBA     Dion Waiters  OKL       SG          80               2205
## 460    NBA     Henry Walker  MIA       SG          24                627
## 461    NBA     Kemba Walker  CHA       PG          62               2118
## 462    NBA        John Wall  WAS       PG          79               2841
## 463    NBA   Gerald Wallace  BOS       SF          32                291
## 464    NBA      T.j. Warren  PHO       SF          40                616
## 465    NBA      C.j. Watson  IND       PG          57               1419
## 466    NBA       David Wear  SAC       PF           2                  7
## 467    NBA      Travis Wear  NYK       SF          51                669
## 468    NBA  Martell Webster  WAS       SF          32                350
## 469    NBA       David West  IND       PF          66               1896
## 470    NBA Russel Westbrook  OKL       PG          67               2302
## 471    NBA Hassan Whiteside  MIA        C          48               1144
## 472    NBA Shay Whittington  IND       PF          20                107
## 473    NBA   Andrew Wiggins  MIN       SG          82               2971
## 474    NBA      C.j. Wilcox  LAC       SG          21                101
## 475    NBA   Deron Williams  BRO       PG          68               2113
## 476    NBA Derrick Williams  SAC       PF          74               1462
## 477    NBA  Elliot Williams  NOR       SG          13                119
## 478    NBA   Louis Williams  TOR       SG          80               2016
## 479    NBA  Marvin Williams  CHA       PF          78               2036
## 480    NBA      Mo Williams  CHA       PG          68               1977
## 481    NBA  Reggie Williams  SAN       SF          20                104
## 482    NBA  Shawne Williams  DET       SF          63               1085
## 483    NBA      Jeff Withey  NOR        C          37                259
## 484    NBA     Nate Wolters  NOR       PG          21                247
## 485    NBA   Brandan Wright  PHO       PF          75               1448
## 486    NBA    Dorell Wright  POR       SF          48                594
## 487    NBA      Tony Wroten  PHI       SG          30                894
## 488    NBA      James Young  BOS       SG          31                334
## 489    NBA       Nick Young  LAL       SF          42                997
## 490    NBA   Thaddeus Young  BRO       SF          76               2434
## 491    NBA      Cody Zeller  CHA        C          62               1487
## 492    NBA     Tyler Zeller  BOS        C          82               1729
##     FieldGoalsMade FieldGoalsAttempted ThreesMade ThreesAttempted
## 1              152                 331         18              60
## 2               35                  86         10              25
## 3              217                 399          0               2
## 4               19                  44          0               0
## 5              375                 884        118             333
## 6              181                 328          0               0
## 7               40                  78          0               5
## 8              144                 301          0               0
## 9              659                1415         37             105
## 10             142                 300          0               0
## 11             225                 455         10              29
## 12             147                 357         34             124
## 13             109                 255          0               1
## 14             120                 207          4              13
## 15             194                 439         73             210
## 16              31                  89          3              11
## 17             291                 729        122             359
## 18             383                 780          7              44
## 19             358                 806         61             179
## 20              36                  62          0               0
## 21             108                 296         52             173
## 22             366                 909        194             555
## 23             155                 384         26             110
## 24             213                 412          0               0
## 25             258                 647         83             246
## 26              55                  95          0               0
## 27              92                 192         59             115
## 28               3                  14          0               0
## 29             183                 386         43             112
## 30             225                 536         54             167
## 31             164                 361         15              41
## 32             316                 656         87             215
## 33             277                 624        136             376
## 34              12                  39          2               4
## 35             150                 353         23              85
## 36             344                 683          9              32
## 37             240                 599        100             308
## 38             220                 516         37             120
## 39             185                 327          1               4
## 40             141                 331         48             132
## 41             364                 852        106             259
## 42              92                 212          8              34
## 43             199                 470         86             230
## 44               0                   0          0               0
## 45             125                 296          7              22
## 46             204                 532        115             323
## 47               1                   2          0               0
## 48             101                 186          0               0
## 49             157                 273          0               1
## 50              26                  57          0               0
## 51             122                 327         77             219
## 52             468                1047         88             272
## 53               9                  30          2              10
## 54             261                 576         91             256
## 55             200                 355          0               0
## 56              94                 230         46             126
## 57             226                 464         29              84
## 58             371                 743          0               0
## 59             343                 745         63             168
## 60             434                1012        124             352
## 61              42                  95          0               1
## 62             343                 806         63             235
## 63             344                 817        121             313
## 64              70                 170         23              62
## 65              52                 122          6              28
## 66              76                 210         17              64
## 67               7                  19          3               7
## 68             266                 713         54             184
## 69             169                 390         52             143
## 70              24                  70         15              46
## 71             370                1005        124             390
## 72             121                 300         26              68
## 73             161                 396         83             219
## 74             421                 912         73             193
## 75             218                 517         91             235
## 76              18                  40          7              11
## 77              10                  31          0               9
## 78               4                  12          2               3
## 79             104                 247         11              44
## 80             147                 354         59             142
## 81             390                 972        153             444
## 82             146                 378         91             246
## 83              14                  29          0               0
## 84             318                 653        120             304
## 85             135                 406         69             232
## 86             364                 919         36             153
## 87             209                 427         35              87
## 88             267                 663         73             248
## 89             293                 440          0               0
## 90             418                 975        139             406
## 91               5                  19          2               9
## 92               3                  12          0               4
## 93               8                  25          3              11
## 94              19                  55         10              30
## 95             267                 595         38             121
## 96               9                  20          6              11
## 97             230                 558         55             176
## 98             260                 550         60             161
## 99             106                 253         16              60
## 100            393                 882        107             277
## 101              9                  22          0               0
## 102            112                 310         52             167
## 103             29                  69          7              20
## 104            498                1066          2               8
## 105            293                 743        163             438
## 106             63                 153         30              85
## 107            332                 839        119             364
## 108            229                 547         61             208
## 109            155                 339          1              10
## 110             12                  33          4              13
## 111              0                   3          0               1
## 112            653                1341        286             646
## 113             57                 130          0               0
## 114             61                 165         43             118
## 115             43                  89         18              40
## 116             55                 137          8              34
## 117            642                1199          1              12
## 118            282                 469          0               0
## 119            117                 255          0               4
## 120              1                   6          1               6
## 121             50                 140         24              70
## 122             91                 162          0               1
## 123            107                 302         64             164
## 124            369                 788         78             221
## 125            409                 990         25              88
## 126            291                 633         54             170
## 127            259                 512          1               6
## 128             51                 169         12              65
## 129             80                 145          0               1
## 130             19                  51          5              18
## 131              5                  21          1               7
## 132            502                1002         90             259
## 133             11                  30          3              14
## 134             20                  58          4              26
## 135            494                 960          0               2
## 136            198                 423         74             192
## 137            419                 819          2               7
## 138            209                 481        107             263
## 139            238                 467         64             159
## 140             76                 214         22              84
## 141            254                 617         90             243
## 142            602                1354         81             284
## 143            101                 247         31              95
## 144             52                 144         12              43
## 145             32                  58          2               5
## 146             58                 137          0               2
## 147            521                1165         69             227
## 148            145                 416         83             264
## 149             76                 139          0               0
## 150            373                 736          1               8
## 151             61                 158         35              97
## 152            482                 918          1               6
## 153             43                 106         10              34
## 154             20                  41          1               2
## 155            253                 575         85             225
## 156            148                 402         94             263
## 157              1                   2          1               2
## 158             21                  61          5              17
## 159             63                 166          9              48
## 160             74                 151          0               0
## 161            191                 487        136             346
## 162            228                 568        107             301
## 163            204                 511         62             176
## 164             17                  63         10              45
## 165            143                 306          1               7
## 166            530                1072          3              17
## 167            570                1154         12              26
## 168            508                1116         79             220
## 169             87                 186         13              35
## 170             18                  49          9              22
## 171            255                 507          0               0
## 172            251                 589         89             258
## 173            258                 427          0               2
## 174            110                 277         23              61
## 175             79                 201         12              41
## 176             93                 208         13              48
## 177            129                 295         35              97
## 178              8                  19          0               3
## 179            285                 693        141             315
## 180            439                 773          0               3
## 181             65                 162         30              84
## 182            124                 352         49             156
## 183            322                 738        191             457
## 184            339                 765        111             329
## 185             61                 162         14              47
## 186            324                 778        137             387
## 187             27                  47          0               6
## 188            416                 967         97             292
## 189            118                 306         42             121
## 190            574                1144         10              25
## 191             22                  41          0               3
## 192             87                 269         49             163
## 193             14                  35         10              21
## 194             85                 178         10              31
## 195             86                 165          1               7
## 196            279                 717        121             354
## 197            647                1470        208             555
## 198             63                 158         10              56
## 199            219                 524         95             266
## 200             66                 217         21             103
## 201             48                 119         31              83
## 202            442                 949         87             239
## 203            107                 239          2              10
## 204            163                 414         55             175
## 205             22                  46          0               0
## 206            484                1087        120             330
## 207             14                  30          0               0
## 208            370                 847         45             136
## 209              3                  13          0               0
## 210            196                 346          1               1
## 211            317                 710          0               2
## 212            218                 459          0               2
## 213            307                 601          1               5
## 214            255                 535         69             193
## 215            357                 777          3              11
## 216            251                 634         68             208
## 217            142                 380         58             168
## 218            238                 534         51             135
## 219             91                 235         35             109
## 220             53                  82          0               0
## 221            155                 374         62             170
## 222            519                 965         11              36
## 223            251                 423          1               2
## 224              6                  14          3               6
## 225             79                 172         16              51
## 226            211                 446          0               7
## 227            374                 786         77             205
## 228            231                 496         74             212
## 229            263                 557         74             190
## 230            147                 354         72             202
## 231            577                1236        155             373
## 232            359                 817         39             146
## 233            432                 996         72             241
## 234             12                  27          0               0
## 235            623                1288        120             342
## 236            485                1009          2               5
## 237             75                 167          2              15
## 238            144                 324         66             155
## 239             49                  99         21              52
## 240            218                 543         76             211
## 241            169                 379         54             140
## 242              7                  26          1              15
## 243            298                 519         19              46
## 244             62                 154         28              95
## 245            238                 404         11              51
## 246            446                1025        121             337
## 247             26                  75          5              21
## 248             70                 167         18              48
## 249            286                 691         91             259
## 250              6                  21          0               4
## 251             73                 197         62             172
## 252             74                 185         15              61
## 253            158                 299         13              37
## 254            379                 534          1               4
## 255             50                  94          0               0
## 256            207                 411         16              44
## 257            283                 549          0               0
## 258            482                 928         16              45
## 259             54                 134         16              54
## 260            104                 309         45             134
## 261            224                 482          0               0
## 262              7                  20          4              13
## 263              0                   5          0               0
## 264              1                   4          0               0
## 265            375                 888        125             321
## 266            292                 599        221             448
## 267            182                 358          0               0
## 268              8                  12          0               0
## 269            104                 250         38             111
## 270            190                 369          0               0
## 271            187                 432         35             116
## 272             36                  89          3              16
## 273            286                 677         57             167
## 274            404                 926         70             205
## 275             32                  96         10              27
## 276            288                 644         90             225
## 277            160                 313          0               2
## 278              0                   1          0               0
## 279            179                 353          1               3
## 280            394                 822         67             192
## 281            125                 245         47             112
## 282            121                 273          7              29
## 283            590                1360        196             572
## 284            277                 655         65             176
## 285            198                 396          0               2
## 286            506                 987          1              10
## 287            234                 437          0               1
## 288            417                 962        146             397
## 289            430                1043        132             391
## 290             42                 104          9              29
## 291              0                   1          0               0
## 292            117                 292         40             127
## 293            116                 211          0               0
## 294             14                  44          4              22
## 295            120                 268         12              46
## 296             46                 101         18              46
## 297             15                  53          6              33
## 298              9                  22          0               0
## 299            268                 625         75             192
## 300            337                 753        173             446
## 301             81                 192          0               0
## 302            296                 700         99             276
## 303            251                 636         62             202
## 304             24                  44          0               0
## 305            206                 470         34             111
## 306            159                 365         55             139
## 307            172                 434         43             150
## 308             43                 107         13              41
## 309             88                 165          0               2
## 310             42                  79          0               0
## 311            363                 831        140             391
## 312              3                  11          1               2
## 313             28                  53          8              19
## 314            222                 534         74             212
## 315              3                  20          0               3
## 316            406                 869        109             268
## 317            329                 827        154             446
## 318            145                 290          7              34
## 319              1                   7          0               1
## 320             37                 114         32              98
## 321              9                  38          3              18
## 322            128                 336         62             182
## 323             81                 238         28              90
## 324            443                 930         77             216
## 325            253                 624         99             313
## 326             12                  29          0               0
## 327            423                 853          0               0
## 328             62                 139         13              38
## 329              1                   1          0               0
## 330             35                 104          7              33
## 331            331                 763        112             313
## 332            512                1100         57             179
## 333            285                 615        141             325
## 334            353                 699         49             132
## 335            318                 571          2               6
## 336            194                 397         20              51
## 337              2                   5          0               0
## 338             83                 151          9              22
## 339             87                 228         43             118
## 340            188                 503         50             164
## 341            205                 504         89             258
## 342             83                 190         13              41
## 343            190                 427          0               2
## 344            302                 653          0               0
## 345              1                   3          0               0
## 346             22                  56         19              48
## 347            487                1062        104             274
## 348            171                 383          0               2
## 349             44                 120          0               0
## 350            119                 242         12              43
## 351            473                1086         84             248
## 352            251                 528         61             175
## 353             12                  14          0               0
## 354            240                 529          0               3
## 355             69                 197         31             106
## 356             15                  35          9              22
## 357            129                 263          4              16
## 358            404                 832         38              89
## 359            383                 829        132             347
## 360            240                 535        105             283
## 361            568                1171        139             350
## 362             91                 220          1               9
## 363            301                 708         11              42
## 364            139                 328          0               0
## 365            100                 225          0               1
## 366            293                 658        118             303
## 367            280                 489          0               3
## 368            136                 254          0               0
## 369            188                 447         91             244
## 370            176                 391         35             104
## 371             31                  67          3              11
## 372             64                 174         16              65
## 373             50                 132         15              54
## 374             77                 223         31             109
## 375             91                 228         57             166
## 376            177                 402         31              67
## 377              3                   8          0               0
## 378              1                   3          0               0
## 379              9                  35          0               5
## 380            454                 932          7              20
## 381            447                 938        200             458
## 382              3                  15          1               7
## 383             62                 178         31              96
## 384             75                 176         20              63
## 385            203                 496         39             131
## 386             92                 201         21              85
## 387            176                 452         62             193
## 388             26                  67          5              19
## 389             88                 255         31             112
## 390            126                 260          0               2
## 391            275                 645         27              86
## 392            338                 835         76             271
## 393            309                 753        145             390
## 394             78                 219         13              51
## 395            119                 263         69             170
## 396             11                  54          3              27
## 397            126                 306          0               1
## 398             16                  48          8              26
## 399            146                 346         31             127
## 400             86                 172          0               0
## 401            284                 664         52             147
## 402            299                 641          5              20
## 403            201                 453         66             192
## 404            104                 248         25              78
## 405            231                 450          0               2
## 406            125                 334         19              60
## 407            188                 466         66             192
## 408            133                 335         47             139
## 409            238                 502          4              22
## 410            172                 446         96             241
## 411            146                 356         41             131
## 412            175                 477         91             272
## 413             30                  49          0               0
## 414            143                 367         18              60
## 415            314                 751        163             423
## 416            257                 592         15              42
## 417            414                 987         72             228
## 418              8                  25          2              11
## 419            159                 371         73             197
## 420            318                 646          5              18
## 421            169                 303          0               0
## 422            108                 296         48             149
## 423            207                 550         18             105
## 424              6                   8          0               0
## 425              2                   6          1               2
## 426             21                  37          0               0
## 427            273                 490          0               4
## 428            332                 754         55             141
## 429            311                 707         52             184
## 430             45                 114         11              36
## 431            408                 886         71             207
## 432            122                 319         62             193
## 433             45                 124         17              59
## 434             68                 170         33              88
## 435            188                 446        126             323
## 436            335                 797        129             346
## 437            182                 442          7              22
## 438             18                  40          0               7
## 439              1                   1          0               0
## 440            224                 543        115             287
## 441            201                 428          0               1
## 442            602                1299        239             545
## 443            266                 489          0               0
## 444            140                 345         54             143
## 445            161                 393        106             290
## 446            261                 596         87             252
## 447              0                   0          0               0
## 448             83                 188         60             139
## 449            320                 746         33             119
## 450             11                  24          0               0
## 451            246                 505         26              97
## 452            373                 652          0               1
## 453            111                 200          0               2
## 454            296                 725        133             351
## 455            150                 362         83             221
## 456             30                  76          5              13
## 457            631                1206          2               6
## 458            509                1084         29             102
## 459            375                 946         73             246
## 460             58                 167         45             131
## 461            378                 981         85             280
## 462            518                1165         65             217
## 463             14                  34          1               3
## 464            113                 214          5              21
## 465            181                 417         70             175
## 466              0                   2          0               1
## 467             84                 209         11              30
## 468             24                  90         10              42
## 469            323                 686          4              20
## 470            627                1471         86             288
## 471            243                 387          0               0
## 472             19                  42          1               6
## 473            497                1140         39             126
## 474             16                  38          7              19
## 475            299                 772         87             237
## 476            217                 485         49             156
## 477             14                  37          8              18
## 478            375                 928        152             447
## 479            211                 496         95             265
## 480            341                 860        119             348
## 481             15                  39          3              19
## 482            121                 300         64             178
## 483             32                  64          0               0
## 484             20                  57          0               7
## 485            233                 363          0               3
## 486             72                 190         41             108
## 487            175                 434         37             142
## 488             36                 102         17              66
## 489            174                 476         83             225
## 490            450                 966         38             115
## 491            172                 373          1               1
## 492            340                 617          0               0
##     FreeThrowsMade FreeThrowsAttempted OffensiveRebounds TotalRebounds
## 1               76                  97                79           301
## 2               14                  23                 9            28
## 3              103                 205               199           522
## 4               22                  38                23            77
## 5              167                 198                27           247
## 6               81                  99               104           315
## 7               13                  27                78           176
## 8               50                  64               101           338
## 9              306                 362               177           726
## 10              33                  48               124           324
## 11              79                 126               103           280
## 12              84                 118               113           341
## 13              41                  87                94           268
## 14              76                 114                76           299
## 15              82                 101                31           204
## 16               9                  14                 5            72
## 17             129                 151               108           294
## 18             257                 347               100           542
## 19             189                 237                72           264
## 20              15                  22                32            94
## 21              88                 123                58           188
## 22             122                 143                77           459
## 23              46                  59                53           171
## 24             131                 225               244           748
## 25             178                 205                20           161
## 26              27                  36                37           117
## 27              13                  19                12           111
## 28               4                   5                 6             8
## 29              58                  74                23            90
## 30              76                  94                23           134
## 31              87                 107                32           127
## 32             108                 150               117           453
## 33              74                  95                51           302
## 34               6                  12                14            28
## 35              74                  94                26           162
## 36             169                 214               139           398
## 37              84                  98                62           416
## 38             121                 137                22           211
## 39              90                 104               109           317
## 40              60                 100                21           222
## 41             130                 166                58           242
## 42              20                  26                12            89
## 43              84                  99                26           157
## 44               0                   0                 1             3
## 45              41                  64                52           216
## 46              45                  60                67           236
## 47               0                   0                 0             1
## 48             102                 175               159           407
## 49              65                 118               142           368
## 50               4                   6                16            56
## 51              29                  41                16           137
## 52             353                 441                73           424
## 53               2                   5                 2             9
## 54              87                 106                50           213
## 55              22                  42               141           543
## 56              30                  37                29           116
## 57              86                 148               139           397
## 58              94                 150               111           482
## 59             179                 232                46           310
## 60              79                 100                46           241
## 61              12                  23                28           100
## 62             168                 226                80           297
## 63             145                 174                32           166
## 64              64                  85                 3            36
## 65              12                  19                14            70
## 66              47                  57                16           107
## 67               3                   4                 0             1
## 68             196                 241                26           199
## 69              67                  81                33           198
## 70               6                   9                 1            50
## 71             109                 145                30           203
## 72             106                 129                19           114
## 73              55                  61                21           196
## 74             386                 463               114           379
## 75              53                  67                27           197
## 76               9                  10                 2            12
## 77               2                   4                 2             6
## 78               0                   0                 1             2
## 79              24                  45                19           106
## 80              29                  32                19           124
## 81             110                 158                46           255
## 82              49                  60                18            87
## 83               4                  23                10            36
## 84             127                 181                99           373
## 85              45                  57                27           133
## 86             202                 291                64           353
## 87             140                 191                54           260
## 88             206                 266                24           206
## 89             185                 257               295           865
## 90             110                 142                96           475
## 91               3                   6                 1             5
## 92               0                   0                 2             6
## 93               1                   4                 1            22
## 94               9                   9                 4            16
## 95             131                 158                56           191
## 96               0                   0                 3            20
## 97              58                  81                13           159
## 98             145                 184                19           143
## 99              45                  65                90           250
## 100            214                 249                29           209
## 101              9                  21                10            25
## 102             33                  45                23           111
## 103             15                  18                 3            18
## 104            423                 541               185           747
## 105            178                 216                65           314
## 106             12                  16                 7            73
## 107            227                 252                18           124
## 108            109                 141                72           293
## 109             29                  47                70           256
## 110              7                  13                 1             9
## 111              0                   0                 0             2
## 112            308                 337                56           342
## 113             14                  20                53           168
## 114             11                  13                 8            33
## 115              1                   1                 3            29
## 116             24                  37                38            83
## 117            371                 461               172           694
## 118             92                 189               230           600
## 119             60                  95                43           168
## 120              0                   0                 0             2
## 121              5                   6                10            75
## 122             34                  64               118           295
## 123             27                  36                38           128
## 124            191                 251               102           375
## 125            361                 434                41           277
## 126             72                  93                78           348
## 127            191                 244               224           610
## 128             31                  34                 4            48
## 129             24                  83               103           279
## 130              8                  13                 2            22
## 131              8                   8                 1            12
## 132            181                 234                81           274
## 133              3                   5                 5             8
## 134              2                   3                 1            15
## 135            142                 365               437          1104
## 136             48                  67                45           220
## 137            230                 311               170           705
## 138             70                  87                28           248
## 139            146                 171                16           178
## 140             36                  48                22            97
## 141             52                  64                31           210
## 142            228                 303                34           190
## 143             79                  94                51           176
## 144              5                   7                 7            35
## 145             24                  29                26            71
## 146             60                  97                97           299
## 147            202                 291                82           418
## 148             20                  32                27           131
## 149             49                  78                60           156
## 150            199                 288               242           668
## 151             10                  11                 8            43
## 152            222                 332               196           607
## 153             12                  15                 2            26
## 154              5                   6                10            26
## 155            107                 147                28           153
## 156             45                  55                 9            84
## 157              0                   0                 1             2
## 158             10                  21                 6            28
## 159             43                  45                 8            40
## 160             21                  25                62           191
## 161             31                  35                27           293
## 162            171                 191                31           218
## 163             63                  78                37           190
## 164              1                   4                 3            17
## 165             36                  45                48           311
## 166            350                 440               115           630
## 167            294                 366               220           919
## 168            337                 393                98           399
## 169             54                  77                37            94
## 170              8                  11                 4            22
## 171            132                 184               163           397
## 172            147                 204                28           211
## 173            170                 273               266           776
## 174             34                  44                72           223
## 175             61                  83                27            74
## 176             44                  61                46           169
## 177             56                  67                 6            63
## 178              1                   2                 7            18
## 179            107                 133                28           159
## 180            123                 175               181           717
## 181             28                  37                20            80
## 182            114                 193                49           198
## 183            111                 127                54           343
## 184            132                 200               114           647
## 185             10                  12                 7            31
## 186             99                 120                33           186
## 187              8                  10                19            45
## 188            239                 287                63           326
## 189             28                  34                14            79
## 190            311                 427               126           508
## 191              9                  13                 5            25
## 192             31                  36                22            92
## 193              0                   0                 2            16
## 194             39                  47                57           134
## 195             97                 139               106           264
## 196            125                 156                12           156
## 197            715                 824                75           460
## 198             22                  41                38           106
## 199            132                 162                13           135
## 200             35                  47                21            64
## 201              9                  15                 7            40
## 202            193                 245                73           430
## 203             45                  64                71           258
## 204             44                  68                30           258
## 205              6                  11                18            51
## 206            375                 462                53           372
## 207              7                  13                 6            29
## 208            184                 217                36           273
## 209             14                  24                 2             4
## 210             78                 137               124           312
## 211            168                 204               156           540
## 212            116                 201               150           452
## 213            122                 202                84           345
## 214            113                 143                25           179
## 215            124                 168               174           556
## 216            159                 193                70           314
## 217             35                  50                20           121
## 218             65                  76                32           136
## 219             37                  45                12            73
## 220             31                  54                36           103
## 221             61                  80                 9           117
## 222            107                 141               131           547
## 223            143                 271               110           431
## 224              3                   4                 1             8
## 225             24                  29                31           134
## 226             87                 117               119           416
## 227             92                 110               135           498
## 228             68                 114                44           257
## 229             69                 107                80           277
## 230             30                  40                22           175
## 231            313                 364                55           241
## 232            200                 227                19           246
## 233            181                 218                56           327
## 234             20                  23                18            39
## 235            374                 529                54           422
## 236            108                 165               100           549
## 237             31                  54                47           145
## 238             78                 114                25           183
## 239             16                  19                 2            39
## 240            120                 143                21           104
## 241             56                  66                93           282
## 242              1                   1                 2             9
## 243             79                 129               158           455
## 244             14                  16                 8            55
## 245             67                 102                61           257
## 246            141                 176                53           384
## 247             17                  25                13            39
## 248             32                  47                14            81
## 249             90                 112                67           319
## 250              9                  11                 1            11
## 251             36                  43                 9            62
## 252             24                  37                 6            76
## 253             57                  94                78           220
## 254            187                 471               397          1226
## 255             38                  44                52           105
## 256            105                 143                44           192
## 257             72                 102               149           484
## 258            183                 234               277           671
## 259             29                  38                22            66
## 260             79                  95                13           146
## 261            150                 214               109           416
## 262              4                   4                 1             6
## 263              3                   4                 2             8
## 264              2                   2                 1             1
## 265            195                 223                28           244
## 266            106                 118                15           303
## 267             55                  85               120           425
## 268              4                   4                 7            17
## 269             49                  55                 8           107
## 270            123                 150                99           268
## 271             61                  78                29           176
## 272             18                  28                27            77
## 273            149                 177                27           214
## 274            265                 363                42           234
## 275             16                  22                16            36
## 276            111                 129                21           178
## 277             68                 104                81           257
## 278              0                   0                 0             0
## 279             73                 104               142           454
## 280            202                 252                85           461
## 281             30                  32                46           250
## 282             37                  59                50           208
## 283            344                 398                49           378
## 284            213                 268                26           196
## 285             65                  91                43           182
## 286            223                 274               214           534
## 287             98                 127               190           394
## 288            258                 322               145           739
## 289            252                 312                54           328
## 290              5                   5                 4            16
## 291              0                   0                 0             0
## 292             25                  31                 8            79
## 293             31                 101               104           355
## 294              5                  16                 5            31
## 295             26                  34                66           205
## 296              8                   9                 2            28
## 297              0                   0                 0            20
## 298              2                   2                 6            19
## 299            170                 193                20           143
## 300            109                 145                38           222
## 301             41                  71                86           203
## 302            115                 139                30           187
## 303             96                 163                82           328
## 304             14                  25                15            37
## 305             57                  84                52           180
## 306             51                  73                14            91
## 307            100                 133                65           200
## 308             10                  15                 6            43
## 309             25                  40                53           165
## 310             22                  33                18            61
## 311            130                 160                31           241
## 312              2                   2                 0             3
## 313              8                  13                 7            45
## 314            145                 160                12           104
## 315              0                   0                 0             1
## 316            134                 156                48           347
## 317            130                 161                18           214
## 318             58                  77                37           153
## 319              0                   0                 0             1
## 320              3                   4                 3            89
## 321              8                  11                 4            20
## 322             33                  40                21            75
## 323             58                  86                28           150
## 324            255                 337               140           570
## 325            228                 284                63           404
## 326              1                   3                10            37
## 327            252                 336               228           703
## 328             12                  20                12            46
## 329              0                   0                 0             1
## 330              4                   8                 7            27
## 331             71                 113                73           385
## 332            177                 232               110           506
## 333             79                  89                41           196
## 334            100                 166               136           420
## 335            154                 214               206           593
## 336            104                 145                63           154
## 337              2                   2                 1             1
## 338             22                  25                52           119
## 339             44                  56                17           113
## 340            117                 135                14           129
## 341             24                  36                33           146
## 342             15                  25                17            82
## 343            105                 174               219           646
## 344            140                 230               185           611
## 345              2                   2                 1             5
## 346              0                   2                 2            22
## 347            255                 289                44           457
## 348             84                 132               125           382
## 349             12                  27                26            64
## 350             44                  57                46           199
## 351            262                 320                51           302
## 352             93                 136                93           304
## 353              3                   8                 7            21
## 354            126                 160               197           500
## 355             13                  18                39           118
## 356              2                   2                 0             3
## 357             46                  66                50           138
## 358            130                 166                15           129
## 359            139                 193                64           323
## 360             63                  80               127           434
## 361            289                 321                52           376
## 362             30                  46                48           162
## 363            118                 214               107           349
## 364            108                 129                89           234
## 365             42                  82                91           318
## 366            164                 210                45           294
## 367            157                 317               175           512
## 368             22                  46               112           320
## 369             71                  96                54           196
## 370             58                  79                70           222
## 371             25                  33                18            50
## 372             33                  49                13            80
## 373             16                  24                 6            31
## 374             36                  45                19            69
## 375             35                  41                30           119
## 376             49                  65                52           209
## 377              2                   2                 2             5
## 378              0                   2                 0             0
## 379              6                  12                16            38
## 380            228                 298               225           747
## 381            183                 203                22           167
## 382              4                   6                 2             4
## 383             17                  22                13            66
## 384             18                  21                 8            68
## 385             85                 126                27           152
## 386             23                  48                60           255
## 387             66                  74                13           109
## 388             16                  24                15            39
## 389             31                  46                17            50
## 390             56                 106                95           303
## 391             31                  78                73           373
## 392            152                 187                35           161
## 393             44                  56                33           227
## 394             57                  71                19           125
## 395             16                  23                 8            47
## 396              5                  11                 4            41
## 397             55                  82                89           233
## 398              2                   4                 4            21
## 399             63                  94                35           163
## 400             24                  48                67           166
## 401            148                 179                29           164
## 402            158                 226               139           527
## 403             61                  77                45           199
## 404             45                  58                53           223
## 405             58                  82                87           288
## 406            133                 173                23           144
## 407             46                  68                53           222
## 408            121                 150                23            99
## 409            106                 137               121           359
## 410             40                  52                33           194
## 411             60                  77                12           143
## 412             82                 127                61           222
## 413             20                  39                26            79
## 414             34                  57                15           100
## 415             53                  70                31           218
## 416            127                 153                98           324
## 417            127                 255               151           529
## 418             12                  13                 1             6
## 419             44                  55                31           176
## 420            150                 178               109           325
## 421             90                 120                91           252
## 422             55                  64                11            88
## 423             69                 110                38           276
## 424              2                   4                 9            15
## 425              3                   6                 0             2
## 426             15                  28                16            34
## 427            134                 186               110           329
## 428            177                 216                36           248
## 429             96                 129               147           441
## 430             26                  41                14            53
## 431            275                 319                29           182
## 432             33                  46                27           194
## 433             24                  34                 2            30
## 434             35                  48                23            89
## 435             39                  48                15           121
## 436            302                 348                33           153
## 437             72                  99                65           195
## 438              9                  13                16            56
## 439              2                   2                 0             0
## 440             63                  89                53           198
## 441             89                 143               139           530
## 442            225                 256                27           246
## 443            159                 246               273           650
## 444             46                  56                23            86
## 445             54                  69                51           236
## 446            104                 143               114           502
## 447              0                   0                 0             1
## 448              6                  11                 5            99
## 449            106                 141                40           417
## 450              7                   9                 7            26
## 451             87                 102                20           143
## 452            217                 276               214           692
## 453             33                  45                57           170
## 454             50                  66                23           217
## 455             20                  35                30           149
## 456             18                  26                28            86
## 457            164                 218               238           810
## 458            284                 370                58           219
## 459            117                 172                40           191
## 460             14                  18                 7            82
## 461            234                 283                35           220
## 462            284                 362                36           364
## 463              6                  15                17            57
## 464             14                  19                41            85
## 465            138                 167                18           163
## 466              0                   0                 2             2
## 467             20                  26                31           106
## 468             48                  64                10            46
## 469            119                 161               108           449
## 470            546                 654               125           490
## 471             78                 156               145           481
## 472             18                  23                10            29
## 473            354                 466               134           374
## 474              2                   2                 1             7
## 475            201                 241                29           237
## 476            134                 196                41           202
## 477              1                   4                 0             8
## 478            340                 395                24           151
## 479             62                  87                58           386
## 480            163                 187                23           175
## 481              4                   4                 5            17
## 482             35                  40                36           166
## 483             34                  50                23            64
## 484              2                   6                 8            34
## 485             78                 112               128           321
## 486             34                  42                14           111
## 487            120                 180                22            86
## 488             16                  29                 9            42
## 489            132                 148                17            96
## 490            131                 200               126           410
## 491            127                 164                97           362
## 492            153                 186               147           466
##     Assists Steals Turnovers Blocks PersonalFouls Disqualifications
## 1        68     27        60     22           147                 1
## 2        16     16        14      7            24                 0
## 3        65     38        99     85           222                 3
## 4        15      4         9      9            30                 0
## 5       129     41       116      7           167                 1
## 6        47     21        69     51           151                 0
## 7        28     17        17     16            96                 1
## 8        75     38        59     65           122                 1
## 9       124     48       122     68           125                 0
## 10       72     15        40     42           102                 0
## 11       86    128        86     30           166                 1
## 12       59     70        55     62           137                 0
## 13       70     22        62     52           126                 1
## 14       43     26        40     61            88                 0
## 15       84     56        60      5           148                 0
## 16       28     15        10      7            28                 0
## 17       56     33        62     20           113                 1
## 18      207     73       173     85           254                 1
## 19      122     40        89     17            87                 0
## 20        5     12        12     49            55                 0
## 21       49     18        49     16           130                 0
## 22      209    152       141     17           186                 0
## 23       57     48        47     26           146                 2
## 24       74     29        95     54           144                 0
## 25      353     49       145      3            93                 0
## 26       14      8        26      8            60                 0
## 27       24     17        26     11            63                 0
## 28        1      2         3      1             8                 0
## 29       99     41        44      8            87                 0
## 30      262     33        70      1           104                 0
## 31       46      2        42     27            53                 1
## 32      116     61        71     19           146                 0
## 33      114     67        87     50           240                 2
## 34        5      4         5      2            26                 0
## 35       81     48        61     19            70                 0
## 36      104     42        83     32           140                 0
## 37      341     78       132     40           106                 0
## 38      234     59       133     12           163                 0
## 39       35     16        65     22           162                 3
## 40       78     52        73     33           127                 0
## 41      194     75       125     16           136                 1
## 42       32     15        37     13            66                 2
## 43       94     31        61      3            85                 0
## 44        0      0         1      0             0                 0
## 45       48     27        36     16            87                 0
## 46      191     59        83     23           182                 3
## 47        1      0         0      1             0                 0
## 48       16     18        52     98           140                 0
## 49       42     19        48     24           158                 2
## 50        3      7        13      1            41                 0
## 51      288     41       104      5           118                 0
## 52      494    127       274     45           189                 1
## 53        8      3         6      0             4                 0
## 54       68     34        78      9           104                 0
## 55      180     39       106    113           188                 2
## 56       47     10        11     12            65                 0
## 57       83     43        88     41           144                 1
## 58       95     41        93     12           184                 2
## 59       95     41        95     24            69                 0
## 60      135     81       109     15           177                 0
## 61       22     17        18     24            54                 0
## 62      174    114       131     19           173                 1
## 63      261     54       157     15           189                 2
## 64       40     12        31      2            33                 0
## 65       90     28        30      6            49                 0
## 66       39     31        27     12            57                 0
## 67        3      4         4      0             8                 0
## 68      197     47       128      7            65                 0
## 69       64     44        49     10            72                 0
## 70        8     10         8      4            19                 0
## 71      328     65       124     16           119                 0
## 72       82     17        52      5            64                 0
## 73       79     43        49      4           120                 0
## 74      212    114        93     36           108                 0
## 75       64     30        48     22            98                 0
## 76       14      3        12      0             3                 0
## 77       18      1         8      1             9                 0
## 78        0      0         4      1             3                 0
## 79      146     63        61      5           100                 1
## 80      198     31        75      0            76                 0
## 81      110     93        94     18           161                 1
## 82       98     29        62      3            83                 0
## 83        2      1         5      9            14                 0
## 84      117     93        76     17           154                 1
## 85       79     43        43     14           102                 0
## 86      443    111       253     30           167                 3
## 87      102     31        88      8           107                 0
## 88      307    122       173     10           251                 2
## 89       84     42       105     91           169                 0
## 90      134     58       110     29           231                 2
## 91        8      6         4      1            10                 0
## 92        0      1         1      0             6                 0
## 93        2      2         6      4            10                 0
## 94       12     10         9      3            20                 0
## 95      206     51        96     12           109                 1
## 96        1      1         4      1            12                 0
## 97      255     57        99     15           124                 1
## 98      251     67       112     14            95                 0
## 99       90     35        45     25           156                 0
## 100     375     89       156     14           139                 0
## 101       1      6         3      3            23                 0
## 102      51     11        59     11            78                 0
## 103      15      4        12      0             6                 0
## 104     210     90       254    104           241                10
## 105     105     97       128     31           185                 1
## 106      39     19        15     15            74                 0
## 107     158     59        92     14           108                 0
## 108      94     72        49     25           137                 0
## 109      50     46        35     37           101                 0
## 110      10      3         7      0            12                 0
## 111       1      0         0      0             2                 0
## 112     619    163       249     16           158                 0
## 113      29     14        39     41            70                 0
## 114      22      6        20      1            40                 0
## 115       9      2         9      7            15                 0
## 116      30     18        29      7            59                 1
## 117     148    100        95    200           141                 0
## 118      94     49        57     98           202                 4
## 119      39     41        39     21           132                 1
## 120       1      0         1      0             3                 0
## 121      17     12        23      5            39                 0
## 122       9     16        51     50           141                 2
## 123     202     22        59      2           152                 0
## 124     139     66       108     22           109                 0
## 125     210     73       137     11           122                 0
## 126     233     36       126     23           148                 0
## 127     146     70       126    125           188                 1
## 128     104     19        33      6            53                 1
## 129      25     40        41     25           157                 1
## 130      24     11        10      4            20                 0
## 131       4      1         0      0            14                 0
## 132     350     78       173     16           195                 2
## 133       5      2         5      0             6                 0
## 134      45      6        25      0            13                 0
## 135      55     73       120    153           285                 7
## 136     130     72        62     11           113                 0
## 137     230     63       132    150           165                 0
## 138     115     39        60     21           123                 0
## 139     110     24        74     25            40                 0
## 140      36     24        40     12            57                 0
## 141     105     33        50      2            77                 0
## 142     329    147       198     25           197                 0
## 143      47     25        39     17            89                 0
## 144      73     18        42      5            36                 0
## 145      13     11         5     12            29                 0
## 146      32     22        45      5            91                 0
## 147     520    100       246     38           198                 3
## 148     198     41       118     14           147                 0
## 149       9      7        32     42            77                 1
## 150      89     62       118     57           211                 2
## 151      67     20        32      5            52                 1
## 152     112     60       121    123           210                 0
## 153      42     11        18      4            17                 0
## 154      15     11         8      0             9                 0
## 155     120     40        82      2           117                 0
## 156     119     34        60     11            97                 0
## 157       3      0         3      1             4                 0
## 158      60      8        25      0            26                 0
## 159      58     15        33      2            43                 0
## 160      16      9        23     23            93                 1
## 161      94     47        78     40           191                 2
## 162      83     47        57     20            94                 0
## 163     150     51        61     12           129                 1
## 164      15      9        10      5            20                 0
## 165      77     46        46     17           109                 0
## 166     307     71       175    131           208                 2
## 167     210     25       158    147           147                 0
## 168     250     71       183     41           157                 1
## 169      25     35        33      7            58                 0
## 170       6      5        12      1            11                 0
## 171      71     36        77     76           162                 1
## 172     293     67       154     20           138                 0
## 173     107     64       111    188           175                 1
## 174      49     21        28      9            91                 0
## 175      44     18        48      9            55                 0
## 176      33     21        38     22            83                 0
## 177      50     14        55      1            60                 0
## 178       2      1         8      0             7                 0
## 179     230     50       122     14           145                 0
## 180      97     50       102    110           192                 1
## 181      17     13        24      6            67                 0
## 182      79     40        85     68           144                 2
## 183     158    101        93     87           163                 0
## 184     291    123       133    100           253                 1
## 185      39     12        14      0            26                 0
## 186      91     42       104     12           145                 1
## 187       4      5        14      5            25                 0
## 188     135     53       108     34           147                 1
## 189      68     26        48      5            81                 0
## 190     353     63       152     35           196                 3
## 191      22      6        12      0            25                 0
## 192      21     21        22     13            61                 0
## 193       7      2         4      0            14                 0
## 194      36     27        26     30            70                 0
## 195      21     30        20     15           141                 1
## 196     127     20        82     14           119                 1
## 197     565    154       321     60           208                 2
## 198      25     32        27      9            66                 0
## 199     236     78        85     14           147                 2
## 200      29     39        38      7            71                 0
## 201      25      7        27      2            62                 1
## 202     123     69       115     36           134                 1
## 203      46     21        41     13           113                 0
## 204      88     24        61     53           173                 0
## 205      20     10         8      4            37                 0
## 206     314    108       206     30           131                 0
## 207       2      2        10     10            17                 0
## 208     206     51       110     22           135                 2
## 209       3      3         3      0             6                 0
## 210      59     28        87    135           152                 0
## 211      84     18       107    125           216                 2
## 212      57     36        96     35           136                 0
## 213     122     67       124     22           180                 2
## 214     220     44        69     14           111                 1
## 215     103     34       106     53           164                 2
## 216     184     66       114     18           177                 0
## 217     148     46        73     14           144                 0
## 218     273     63        91     22           110                 1
## 219      48     40        29     12            54                 0
## 220      14      6        25     19            65                 0
## 221      83     30        45     12           119                 0
## 222     244     68       100     97           123                 0
## 223      50     28       115     53           137                 1
## 224       5      6         3      1             4                 0
## 225      27     15        18      9            86                 0
## 226      58     34        49     25           133                 0
## 227      56     30        97    154           194                 4
## 228     227     89        88     25           100                 0
## 229      56     36        45     19           149                 1
## 230     182     72        98     10           124                 1
## 231     389    111       187     20           145                 0
## 232     373     75       191     13           143                 1
## 233     460     62       186      9           167                 1
## 234       4      2         6     15            17                 0
## 235     509    108       274     47           132                 0
## 236     113     47        68     85           139                 0
## 237      16     10        20     21            61                 0
## 238      61     32        52     11           115                 0
## 239      13     10         8      0            15                 0
## 240     272     44        90      4            64                 0
## 241      71     46        44     18           135                 0
## 242       3      2         3      2            11                 0
## 243     117     44       110     59           225                 1
## 244      15     26        15      7            44                 0
## 245      95     53        79     70           155                 1
## 246     292     59       137     14           120                 0
## 247      11      7        19      3            34                 0
## 248      42     33        30      9            42                 0
## 249     123     59        87     45           162                 4
## 250       2      3         1      0            23                 0
## 251      24     13        13      8            63                 0
## 252      18     17        24      8            50                 0
## 253      36     18        37     59            78                 0
## 254      61     82       109    182           245                 1
## 255      13      8        22     15            58                 0
## 256     188     46        67     17           105                 0
## 257      65     18       108     54           140                 1
## 258      56     36       145     29           189                 2
## 259      46     23        24      1            45                 0
## 260      92     29        37     24           118                 1
## 261      77     30        63     38           115                 1
## 262       4      3         2      0             3                 0
## 263       1      1         1      0             1                 0
## 264       1      0         0      0             1                 0
## 265     331     90       189     10           114                 1
## 266     196     54       109     42           140                 1
## 267      37     29        69     63           148                 0
## 268       6      2         5      1            13                 0
## 269      44     21        27      6            52                 1
## 270      26     15        54     17           132                 1
## 271     226     93        83      9           150                 1
## 272      13      8        23     11            44                 1
## 273     276     54       193     10           158                 0
## 274     720     92       185      9           128                 0
## 275      19      6        26      1            21                 0
## 276     151     75        78     12           129                 1
## 277      86     31        49     26            83                 0
## 278       0      0         0      0             0                 0
## 279      32     34        74    105           213                 4
## 280     161    148        97     48           128                 0
## 281      32     10        39     14           113                 0
## 282      46     17        35      9            86                 1
## 283     506     97       222     21           164                 0
## 284     340     83       167     31           189                 1
## 285     258     50       102     20           110                 0
## 286      50     43       104    126           206                 0
## 287      56     16        73     84           122                 0
## 288     169     53       124     41           141                 1
## 289     473    109       173     13           212                 1
## 290      60      8        16      0            18                 0
## 291       0      1         0      0             1                 0
## 292     155     29        49      2            32                 0
## 293      33     30        59     46           172                 1
## 294      17      9         9      2            14                 0
## 295      52     27        35     27            59                 0
## 296      85     21        35      0            26                 0
## 297      11      3         5      1            20                 0
## 298       5      5         3      6            13                 0
## 299      89     33        76      1            76                 0
## 300     139     77        81     10           132                 1
## 301      19     18        29     44            96                 1
## 302     197     57       128     18           165                 2
## 303     106     81        99     21           104                 0
## 304       2      5         6      9            21                 0
## 305     188     45        85     11            92                 0
## 306      64     43        48      8            81                 0
## 307      72     44       105     70           126                 0
## 308       6      4        17      1            29                 0
## 309      14     16        31     16            72                 1
## 310       3      2        18     20            30                 0
## 311     141     77       138     19           219                 3
## 312       2      3         5      1             5                 0
## 313      33     12        22      3            41                 0
## 314      79     59        57      6            76                 0
## 315      13      2         2      0             1                 0
## 316     182    122       113     11           183                 1
## 317      75     60        73     26           132                 0
## 318     283     32       104      6           103                 0
## 319       2      1         1      0             8                 0
## 320      45     14        23      4            74                 0
## 321       8      7         5      5             9                 0
## 322      87     28        35      2            58                 0
## 323      58     55        67     16           124                 0
## 324     223    128       167     69           199                 0
## 325      97     54        89     53           172                 1
## 326       3      4         7      5            16                 0
## 327     142     78       149     34           148                 0
## 328      33     20        14      6            45                 0
## 329       0      0         0      0             1                 0
## 330      47      9        20      0            20                 0
## 331     133     63        73     16           188                 2
## 332     191    101       170     39           245                 4
## 333      61     54        39     11           135                 1
## 334     129     56       123     34           203                 1
## 335      56     33       117     96           228                 2
## 336      43     18        35      7            49                 0
## 337       1      1         4      0             2                 0
## 338      25     16        21     19            52                 0
## 339     130     40        81      4            76                 0
## 340     100     23        65      1            88                 0
## 341     253     47       109      6           136                 1
## 342      22      6        24     12            51                 0
## 343     311     48       123     74           203                 3
## 344     128    133       146    142           208                 2
## 345       1      1         0      0             3                 0
## 346      11      0         5      2            23                 0
## 347     143     39        82     33           160                 1
## 348      50     52        85     68           207                 6
## 349      17      5        25      4            44                 0
## 350      59     31        55     38           110                 0
## 351     295    120       204     19           187                 1
## 352     108     64        98     39           213                 1
## 353       4      1         2      3             6                 0
## 354     178     80       133     21           170                 0
## 355      85     29        55     13            71                 0
## 356       8      0         3      0             8                 0
## 357      42     31        47      5            42                 0
## 358     335     44       146      2           108                 0
## 359     162     69        96     19           140                 2
## 360     155     60        54     44           149                 0
## 361     838    156       190     15           203                 2
## 362      30     19        44      9            88                 0
## 363     533    142       203     20           193                 0
## 364      27     19        42     12            59                 0
## 365      51     16        95     42           162                 1
## 366     144     46        91     24           159                 1
## 367      74     65       106     63           207                 0
## 368      34     41        51     66           111                 0
## 369      93     19        51     24           150                 0
## 370      65     44        53     30            97                 0
## 371       9      9        11      6            40                 1
## 372     116     30        41      6            54                 0
## 373      45      7        14      0            13                 0
## 374     165     67        52      4           118                 2
## 375     171     79        62      1            88                 0
## 376      93     29        35     16            55                 0
## 377       0      1         2      0             8                 0
## 378       0      0         1      0             1                 0
## 379       4      5         3      3            16                 0
## 380     153     69       157     14           175                 1
## 381     138     39        95      8           134                 0
## 382       2      0         2      0            11                 0
## 383      38     13        16      3            28                 0
## 384      96     20        38      4            66                 0
## 385     155     48        65     14           146                 0
## 386      70     53        46     29           141                 0
## 387     162     32        57      6            75                 0
## 388      11      6        11      1            15                 0
## 389      97     20        30      3            76                 0
## 390      33     33        59     20           104                 0
## 391     538     91       210      7           153                 1
## 392     251     36       161     16            63                 0
## 393      86     53        69     25           136                 1
## 394     193     40        64      1            59                 1
## 395      53     16        48      5            79                 0
## 396      12      5        11     12            27                 0
## 397      55     28        36     43           121                 1
## 398      13      9         5      4            25                 0
## 399      77     38        76     26           135                 0
## 400      23     26        28     39           104                 0
## 401     317     49       149      4           127                 0
## 402     106     47        94     18           192                 0
## 403      75     25        39      3            83                 0
## 404      75     53        39     20            67                 0
## 405      59     10        98     59           197                 1
## 406     182     29        86      0            73                 0
## 407     134     80        89     16           136                 2
## 408     106     30        48      6            48                 0
## 409      79     39        99     30           135                 0
## 410      85     47        55     21           153                 0
## 411     190     23        65      0            47                 0
## 412     208     99        90     18           176                 2
## 413       9      7        11     11            53                 0
## 414     180     36        78      6            50                 0
## 415     193     82        97     20           161                 1
## 416     140     32       104     44           205                 2
## 417     276     87       206    116           228                 2
## 418       8      3        12      0            13                 0
## 419      62     32        48     11            86                 0
## 420      73     20        82     35           189                 4
## 421      78     35        60     37           103                 0
## 422      67     20        40     17            92                 0
## 423     240     38       128      8           134                 0
## 424       3      2         7      0            15                 0
## 425       9      2         4      0             1                 0
## 426       4      5         7      5            25                 1
## 427      45     29        78     38           161                 3
## 428     219     56       118     10           131                 0
## 429     134     44        78     42           153                 0
## 430      22     12        19      1            36                 0
## 431     513    124       206     31           140                 0
## 432      45     14        53     16            74                 0
## 433      45     10        18      0            29                 0
## 434      56     42        33      9            76                 0
## 435     147     66        74     19           116                 0
## 436     284     57       143      5           150                 0
## 437      69     37        74      8           101                 1
## 438       7      3        13      1            17                 0
## 439       1      0         0      0             0                 0
## 440      85     57        65     26           141                 1
## 441      85     33        84     57           239                 4
## 442     221     87       149     60           122                 0
## 443      39     33        82     59           189                 1
## 444      36     27        27      7            38                 0
## 445      59     24        51     16           137                 2
## 446     121    107        96     23           179                 0
## 447       2      0         0      0             0                 0
## 448      37     19        29      7            66                 0
## 449     450     83       198     19           180                 1
## 450       8      8         7      7            20                 0
## 451     220     46        89      8            88                 0
## 452      39     34       109     95           222                 3
## 453      36     19        35     16            58                 0
## 454     302     46       119     10           177                 1
## 455      19     15        28     22            64                 0
## 456       4      4        11      9            20                 0
## 457     148     54       148     54           220                 3
## 458     299     73       209     21           105                 0
## 459     163     91       113     21           155                 0
## 460      29     24        24      9            76                 2
## 461     318     89       100     31            92                 0
## 462     791    138       303     46           179                 0
## 463      11     15        18      4            19                 0
## 464      25     18        27      9            51                 1
## 465     208     57       100      9           107                 0
## 466       1      0         0      0             1                 0
## 467      40     15        35     11            55                 0
## 468      17      7        22      1            24                 0
## 469     223     48       120     48           160                 0
## 470     575    140       294     14           184                 2
## 471       6     28        58    122           129                 1
## 472       6      5         5      2            18                 0
## 473     171     85       176     50           190                 0
## 474       8      3        10      1             7                 0
## 475     448     64       154     17           157                 0
## 476      50     34        56      4            67                 0
## 477      12      4         4      0            12                 0
## 478     164     88       101     10           103                 0
## 479     100     69        60     36           146                 0
## 480     424     46       173     15           162                 0
## 481      10      1         2      0            12                 0
## 482      44     25        30     21           135                 0
## 483      11      4        12     18            26                 0
## 484      21      8        13      2            18                 0
## 485      41     50        34     94           102                 0
## 486      41     20        18     10            55                 1
## 487     156     48       114      8            72                 1
## 488      13      8         5      2            22                 0
## 489      41     23        44     11            83                 0
## 490     173    123       117     25           171                 1
## 491     100     35        62     49           156                 0
## 492     114     18        77     52           205                 1
##     TotalPoints Technicals Ejections FlagrantFouls GamesStarted
## 1           398          5         0             0           22
## 2            94          0         0             0            0
## 3           537          3         0             0           67
## 4            60          0         0             0            0
## 5          1035          0         0             0           72
## 6           443          1         0             0            8
## 7            93          0         0             0           10
## 8           338          0         0             0           16
## 9          1661          2         0             0           71
## 10          317          0         0             0            0
## 11          539          5         0             0           41
## 12          412          3         0             0            3
## 13          259          1         0             0           35
## 14          320          2         0             0           20
## 15          543          2         0             0           19
## 16           74          0         0             0            8
## 17          833          3         0             0            5
## 18         1030          3         0             0           71
## 19          966          1         0             0           40
## 20           87          0         0             0            0
## 21          356          3         0             0            3
## 22         1048          4         0             0           82
## 23          382          3         0             0            4
## 24          557          1         0             0           76
## 25          777          1         0             0           14
## 26          137          1         0             0            0
## 27          256          0         0             0           19
## 28           10          0         0             0            1
## 29          467          0         0             0            1
## 30          580          0         0             0           10
## 31          430          0         0             0           22
## 32          827          0         0             0           82
## 33          764         13         0             0           74
## 34           32          0         0             0            1
## 35          397          1         0             0            0
## 36          866          1         0             0           43
## 37          664          1         0             0           71
## 38          598          6         0             0            4
## 39          461          2         0             0           17
## 40          390          1         0             0           10
## 41          964          1         0             0           59
## 42          212          4         0             0            1
## 43          568          0         0             0            9
## 44            0          0         0             0            0
## 45          298          1         0             0            3
## 46          568          6         0             0           55
## 47            2          0         0             0            0
## 48          304          2         0             0           21
## 49          379          0         0             0           39
## 50           56          0         0             0            0
## 51          350          3         0             0            0
## 52         1377         10         0             0           81
## 53           22          0         0             0            1
## 54          700          1         0             0           28
## 55          422          0         0             0           65
## 56          264          0         0             0           19
## 57          567          4         0             0            5
## 58          836          2         0             0           26
## 59          928          0         0             0           44
## 60         1071          0         0             0           77
## 61           96          0         0             0            4
## 62          917          3         0             0           17
## 63          954          6         0             0           21
## 64          227          0         0             0            5
## 65          122          0         0             0            7
## 66          216          1         0             0           29
## 67           20          0         0             0            2
## 68          782          4         0             0           35
## 69          457          1         0             0            4
## 70           69          0         0             0            2
## 71          973          0         0             0           43
## 72          374          1         0             0           27
## 73          460          1         0             0           21
## 74         1301          2         0             0           65
## 75          580          0         0             0            1
## 76           52          0         0             0            0
## 77           22          0         0             0            0
## 78           10          0         0             0            0
## 79          243          1         0             0            0
## 80          382          0         0             0           42
## 81         1043          2         0             0           82
## 82          432          1         0             0           21
## 83           32          0         0             0            0
## 84          883          4         0             0           69
## 85          384          6         0             0            1
## 86          966          4         0             0           63
## 87          593          2         0             0           19
## 88          813          2         0             0           37
## 89          771         11         0             0           75
## 90         1085          0         0             0           75
## 91           15          0         0             0            0
## 92            6          0         0             0            1
## 93           20          0         0             0            0
## 94           57          0         0             0            0
## 95          703          0         0             0           38
## 96           24          0         0             0            0
## 97          573          1         0             0           25
## 98          725          0         0             0           45
## 99          273          3         0             0            2
## 100        1107          1         0             0           70
## 101          27          0         0             0            0
## 102         309          0         0             0           12
## 103          80          0         0             0            0
## 104        1421         15         0             0           59
## 105         927          0         0             0           48
## 106         168          0         0             0            9
## 107        1010          5         0             0            4
## 108         628          1         0             0           17
## 109         340          0         0             0           27
## 110          35          0         0             0            0
## 111           0          0         0             0            0
## 112        1900          2         0             0           80
## 113         128          0         0             0           21
## 114         176          0         0             0            0
## 115         105          0         0             0            1
## 116         142          0         0             0            6
## 117        1656          2         0             0           68
## 118         656          1         0             0           24
## 119         294          0         0             0            0
## 120           3          0         0             0            0
## 121         129          0         0             0            4
## 122         216          2         0             0           15
## 123         305          0         0             0           13
## 124        1007          2         0             0           72
## 125        1204          6         0             0           60
## 126         708          1         0             0           15
## 127         710          0         0             0           49
## 128         145          0         0             0            1
## 129         184          3         0             0           17
## 130          51          0         0             0            0
## 131          19          0         0             0            0
## 132        1275          4         0             0           77
## 133          28          0         0             0            1
## 134          46          0         0             0            1
## 135        1130          4         0             0           82
## 136         518          2         0             0           22
## 137        1070          1         0             0           77
## 138         595          1         0             0           63
## 139         686          4         0             0           27
## 140         210          1         0             0            7
## 141         650          1         0             0           36
## 142        1513          3         0             0           80
## 143         312          0         0             0            3
## 144         121          0         0             0            1
## 145          90          0         0             0            0
## 146         176          1         0             0            7
## 147        1313          3         0             0           76
## 148         393          0         0             0           41
## 149         201          2         0             0            7
## 150         946          8         0             0           71
## 151         167          0         0             0            0
## 152        1187          0         0             0           74
## 153         108          0         0             0            3
## 154          46          0         0             0            9
## 155         698          1         0             0           32
## 156         435          0         0             0           21
## 157           3          0         0             0            0
## 158          57          0         0             0            3
## 159         178          0         0             0            0
## 160         169          5         0             0            8
## 161         549          2         0             0           51
## 162         734          0         0             0           27
## 163         533          0         0             0           41
## 164          45          0         0             0            0
## 165         323          8         0             0           47
## 166        1413          6         0             0           81
## 167        1446          0         0             0           78
## 168        1432          8         0             0           67
## 169         241          0         0             0            2
## 170          53          0         0             0            0
## 171         642          3         0             0           17
## 172         738          0         0             0            0
## 173         686          3         0             0           37
## 174         277          0         0             0            7
## 175         231          1         0             0            2
## 176         243          0         0             0            8
## 177         349          1         0             0            0
## 178          17          0         0             0            0
## 179         818          0         0             0           60
## 180        1001          4         0             0           82
## 181         188          0         0             0            6
## 182         411          0         0             0           11
## 183         946          1         0             0           80
## 184         921         11         0             0           79
## 185         146          0         0             0            1
## 186         884          3         0             0            4
## 187          62          0         0             0            1
## 188        1168          1         0             0           70
## 189         306          0         0             0            2
## 190        1469         12         0             0           67
## 191          53          0         0             0            1
## 192         254          1         0             0            2
## 193          38          0         0             0            2
## 194         219          0         0             0           14
## 195         270          2         0             0            8
## 196         804          2         0             0           30
## 197        2217          6         0             0           81
## 198         158          0         0             0            4
## 199         665          1         0             0            3
## 200         188          0         0             0            6
## 201         136          0         0             0            1
## 202        1164          3         0             0           63
## 203         261          2         0             0           25
## 204         425          6         0             0           15
## 205          50          1         0             0            0
## 206        1463          0         0             0           76
## 207          35          0         0             0            1
## 208         969         10         0             0           72
## 209          20          0         0             0            0
## 210         471          4         0             0           11
## 211         802          7         0             0           76
## 212         552          0         0             0            8
## 213         737          4         0             0           58
## 214         692          4         1             0           36
## 215         841          1         0             0           57
## 216         729          1         0             0           78
## 217         377          3         0             0           22
## 218         592          0         0             0           37
## 219         254          0         0             0            4
## 220         137          2         0             0            9
## 221         433          1         0             0           21
## 222        1156          2         0             0           76
## 223         646          6         0             0           41
## 224          18          0         0             0            0
## 225         198          0         0             0            4
## 226         509          1         0             0           17
## 227         917          2         0             0           64
## 228         604          2         0             0            0
## 229         669          0         0             0           36
## 230         396          3         0             0           32
## 231        1622          1         0             0           75
## 232         957          1         0             0           27
## 233        1117          1         0             0           40
## 234          44          0         0             0            2
## 235        1740          5         0             0           69
## 236        1080          3         0             0           61
## 237         183          0         0             0            1
## 238         432          0         0             0           18
## 239         135          0         0             0            3
## 240         632          3         0             0           41
## 241         448          1         0             0            0
## 242          16          0         0             0            0
## 243         694          1         0             0           72
## 244         166          0         0             0            2
## 245         554          4         0             0           17
## 246        1154          0         0             0           80
## 247          74          0         0             0            0
## 248         190          0         0             0            2
## 249         753          0         0             0           59
## 250          21          0         0             0            0
## 251         244          0         0             0            1
## 252         187          0         0             0           13
## 253         386          2         0             0           24
## 254         946          9         0             0           82
## 255         138          0         0             0            0
## 256         535          1         0             0           14
## 257         638          5         0             0           13
## 258        1163          5         0             0           74
## 259         153          0         0             0           16
## 260         332          0         0             0           34
## 261         598          1         0             0           52
## 262          22          0         0             0            0
## 263           3          0         0             0            0
## 264           4          0         0             0            0
## 265        1070          1         0             0           61
## 266         911          0         0             0           75
## 267         419          4         0             0            3
## 268          20          0         0             0            0
## 269         295          0         0             0            8
## 270         503          2         0             0           15
## 271         470          0         0             0           22
## 272          93          1         0             0            1
## 273         778          0         0             0           40
## 274        1143          0         0             0           75
## 275          90          0         0             0            0
## 276         777          0         0             0           74
## 277         388          0         0             0            4
## 278           0          0         0             0            0
## 279         432          1         0             0           44
## 280        1057          0         0             0           64
## 281         327          0         0             0            7
## 282         286          0         0             0            6
## 283        1720          1         0             0           82
## 284         832          0         0             0           30
## 285         461          2         0             0            2
## 286        1236          1         0             0           44
## 287         566          3         0             0           59
## 288        1238          1         0             0           76
## 289        1244          8         0             0           70
## 290          98          0         0             0            0
## 291           0          0         0             0            0
## 292         299          1         0             0            0
## 293         263          4         0             0            6
## 294          37          0         0             0            7
## 295         278          1         0             0           24
## 296         118          0         0             0            3
## 297          36          0         0             0            0
## 298          20          0         0             0            0
## 299         781          0         0             0           36
## 300         956          5         0             0           60
## 301         203          0         0             0            0
## 302         806          9         0             0           15
## 303         660          0         0             0           61
## 304          62          0         0             0            0
## 305         503          0         0             0           30
## 306         424          1         0             0            3
## 307         487          3         0             0           15
## 308         109          0         0             0            0
## 309         201          0         0             0            2
## 310         106          0         0             0            0
## 311         996          1         0             0           82
## 312           9          0         0             0            0
## 313          72          0         0             0            4
## 314         663          1         0             0            0
## 315           6          0         0             0            0
## 316        1055          3         0             0           58
## 317         942          0         0             0           40
## 318         355          2         0             0            0
## 319           2          0         0             0            1
## 320         109          0         0             0           15
## 321          29          0         0             0            0
## 322         351          0         0             0            0
## 323         248          1         0             0            5
## 324        1218          3         0             0           73
## 325         833          0         0             0            3
## 326          25          0         0             0            0
## 327        1098          4         0             0           57
## 328         149          0         0             0            0
## 329           2          0         0             0            0
## 330          81          0         0             0            0
## 331         845         10         0             0           35
## 332        1258         15         0             0           82
## 333         790          3         0             0            0
## 334         855          2         0             0           62
## 335         792          6         0             0           80
## 336         512          1         0             0           13
## 337           6          0         0             0            0
## 338         197          0         0             0            8
## 339         261          0         0             0           10
## 340         543          1         0             0            1
## 341         523          1         0             0           29
## 342         194          0         0             0            3
## 343         485          5         0             0           67
## 344         744          1         0             0           71
## 345           4          0         0             0            0
## 346          63          0         0             0            0
## 347        1333          5         0             0           77
## 348         426          3         0             0           27
## 349         100          0         0             0           15
## 350         294          1         0             0           17
## 351        1292          1         0             0           71
## 352         656          0         0             0           13
## 353          27          0         0             0            1
## 354         606          3         0             0           45
## 355         182          1         0             0            1
## 356          41          0         0             0            0
## 357         308          0         0             0           25
## 358         976          2         0             0           68
## 359        1037          2         0             0           66
## 360         648          1         0             0            4
## 361        1564          6         0             0           82
## 362         213          0         0             0           22
## 363         731          1         0             0           63
## 364         386          1         0             0           29
## 365         242          7         0             0            3
## 366         868          3         0             0           73
## 367         717          1         0             0           45
## 368         294          0         0             0           28
## 369         538          3         0             0           30
## 370         445          0         0             0           13
## 371          90          0         0             0            0
## 372         177          0         0             0            0
## 373         131          0         0             0            0
## 374         221          0         0             0           20
## 375         274          3         0             0            3
## 376         434          0         0             0           16
## 377           8          0         0             0            0
## 378           2          0         0             0            0
## 379          24          0         0             0            1
## 380        1143          6         0             0           71
## 381        1277          4         0             0           78
## 382          11          0         0             0            0
## 383         172          1         0             0           15
## 384         188          0         0             0            0
## 385         530          5         0             0            5
## 386         228          1         0             0           65
## 387         480          0         0             0           10
## 388          73          0         0             0            1
## 389         238          2         0             0            1
## 390         308          1         0             0            4
## 391         608          2         0             0           68
## 392         904          3         0             0           51
## 393         807          2         0             0           61
## 394         226          0         0             0           22
## 395         323          0         0             0            2
## 396          30          0         0             0            0
## 397         307          0         0             0           18
## 398          42          0         0             0            0
## 399         386          1         0             0           32
## 400         196          4         0             0           26
## 401         768          4         0             0           10
## 402         761          0         0             0           16
## 403         529          1         0             0            0
## 404         278          0         0             0            7
## 405         520          1         0             0            0
## 406         402          0         0             0           10
## 407         488          0         0             0           25
## 408         434          0         0             0            9
## 409         586          2         0             0           32
## 410         480          1         0             0           58
## 411         393          0         0             0           21
## 412         523          2         0             0           38
## 413          80          0         0             0            2
## 414         338          0         0             0           14
## 415         844          5         0             0           51
## 416         656          3         0             0           31
## 417        1027          9         0             0           35
## 418          30          0         0             0            0
## 419         435          0         0             0           22
## 420         791          3         0             0            9
## 421         428          0         0             0           35
## 422         319          0         0             0            1
## 423         501          5         0             0           25
## 424          14          0         0             0            0
## 425           8          0         0             0            0
## 426          57          0         0             0            2
## 427         680          6         0             0           15
## 428         896          1         0             0           36
## 429         770          2         0             0           49
## 430         127          0         0             0           13
## 431        1162          1         0             0           72
## 432         339          0         0             0            4
## 433         131          3         0             0            1
## 434         204          0         0             0           18
## 435         541          3         0             0           18
## 436        1101          6         0             0            1
## 437         443          0         0             0           37
## 438          45          0         0             0            0
## 439           4          0         0             0            0
## 440         626          0         0             0           23
## 441         491          6         0             0           63
## 442        1668          1         0             0           77
## 443         691          2         0             0           15
## 444         380          1         0             0            0
## 445         482          0         0             0           11
## 446         713          8         0             0           63
## 447           0          0         0             0            0
## 448         232          2         0             0            2
## 449         779          3         0             0           57
## 450          29          0         0             0            0
## 451         605          1         0             0           12
## 452         963          3         0             0           80
## 453         255          1         0             0           26
## 454         775          3         0             0           29
## 455         403          1         0             0            1
## 456          83          1         0             0            0
## 457        1428          3         0             0           74
## 458        1331          2         0             0           62
## 459         940          7         0             0           23
## 460         175          4         0             0           13
## 461        1075          5         0             0           58
## 462        1385          6         0             0           79
## 463          35          0         0             0            0
## 464         245          0         0             0            1
## 465         570          1         0             0           21
## 466           0          0         0             0            0
## 467         199          0         0             0            1
## 468         106          0         0             0            0
## 469         769          7         0             0           66
## 470        1886         15         0             0           67
## 471         564          7         0             0           32
## 472          57          0         0             0            0
## 473        1387          1         0             0           82
## 474          41          0         0             0            0
## 475         886          3         0             0           55
## 476         617          1         0             0            6
## 477          37          0         0             0            0
## 478        1242          3         0             0            0
## 479         579          3         0             0           37
## 480         964          1         0             0           33
## 481          37          0         0             0            0
## 482         341          2         0             0           22
## 483          98          0         0             0            0
## 484          42          0         0             0            0
## 485         544          0         0             0            7
## 486         219          0         0             0            2
## 487         507          3         0             0           15
## 488         105          0         0             0            0
## 489         563          5         0             0            0
## 490        1069          0         0             0           68
## 491         472          1         0             0           45
## 492         833          0         0             0           59

真實世界裡的資料 Raw Data: Html

真實世界裡的資料 Raw Data: Facebook

真實世界裡的資料 Raw Data: ?!

資料到底在哪裡?

Open Data Example

Open Data Example

Reading Data

讀檔的基本函數們:

  • read.table, read.csv, for reading tabular data
  • readLines, for reading lines of a text file
  • source, for reading in R code files (inverse of dump)
  • dget, for reading in R code files (inverse of dput)
  • load, for reading in saved workspaces

Writing Data

There are analogous functions for writing data to files

  • write.table
  • writeLines
  • dump
  • dput
  • save
  • serialize

Reading Data Files with read.table

The read.table function is one of the most commonly used functions for reading data. It has a few important arguments: - file, the name of a file, or a connection - header, logical indicating if the file has a header line - sep, a string indicating how the columns are separated - colClasses, a character vector indicating the class of each column in the dataset - nrows, the number of rows in the dataset - comment.char, a character string indicating the comment character - skip, the number of lines to skip from the beginning - stringsAsFactors, should character variables be coded as factors?

read.table

For small to moderately sized datasets, you can usually call read.table without specifying any other arguments

data <- read.table("foo.txt")

R will automatically

  • skip lines that begin with a #
  • figure out how many rows there are (and how much memory needs to be allocated)
  • figure what type of variable is in each column of the table Telling R all these things directly makes R run faster and more efficiently.
  • read.csv is identical to read.table except that the default separator is a comma.

Reading in Larger Datasets with read.table

With much larger datasets, doing the following things will make your life easier and will prevent R from choking.

  • Read the help page for read.table, which contains many hints
  • Make a rough calculation of the memory required to store your dataset. If the dataset is larger than the amount of RAM on your computer, you can probably stop right here.
  • Set comment.char = "" if there are no commented lines in your file.

Reading in Larger Datasets with read.table

  • Use the colClasses argument. Specifying this option instead of using the default can make ’read.table’ run MUCH faster, often twice as fast. In order to use this option, you have to know the class of each column in your data frame. If all of the columns are “numeric”, for example, then you can just set colClasses = "numeric". A quick an dirty way to figure out the classes of each column is the following:
initial <- read.table("datatable.txt", nrows = 100)
classes <- sapply(initial, class)
tabAll <- read.table("datatable.txt",
                     colClasses = classes)
  • Set nrows. This doesn’t make R run faster but it helps with memory usage. A mild overestimate is okay. You can use the Unix tool wc to calculate the number of lines in a file.

Know Thy System

In general, when using R with larger datasets, it’s useful to know a few things about your system.

  • How much memory is available?
  • What other applications are in use?
  • Are there other users logged into the same system?
  • What operating system?
  • Is the OS 32 or 64 bit?

Calculating Memory Requirements

I have a data frame with 1,500,000 rows and 120 columns, all of which are numeric data. Roughly, how much memory is required to store this data frame?

1,500,000 × 120 × 8 bytes/numeric

= 1440000000 bytes

= 1440000000 / \(2^{20}\) bytes/MB

= 1,373.29 MB

= 1.34 GB

Textual Formats

  • dumping and dputing are useful because the resulting textual format is edit-able, and in the case of corruption, potentially recoverable.
  • Unlike writing out a table or csv file, dump and dput preserve the metadata (sacrificing some readability), so that another user doesn’t have to specify it all over again.
  • Textual formats can work much better with version control programs like subversion or git which can only track changes meaningfully in text files
  • Textual formats can be longer-lived; if there is corruption somewhere in the file, it can be easier to fix the problem
  • Textual formats adhere to the “Unix philosophy”
  • Downside: The format is not very space-efficient

dput-ting R Objects

Another way to pass data around is by deparsing the R object with dput and reading it back in using dget.

> y <- data.frame(a = 1, b = "a")
> dput(y)
structure(list(a = 1,
               b = structure(1L, .Label = "a",
                             class = "factor")),
          .Names = c("a", "b"), row.names = c(NA, -1L),
          class = "data.frame")
> dput(y, file = "y.R")
> new.y <- dget("y.R")
> new.y
   a  b 
1  1  a

Dumping R Objects

Multiple objects can be deparsed using the dump function and read back in using source.

> x <- "foo"
> y <- data.frame(a = 1, b = "a")
> dump(c("x", "y"), file = "data.R") 
> rm(x, y)
> source("data.R")
> y
  a  b 
1 1  a
> x
[1] "foo"

Interfaces to the Outside World

Data are read in using connection interfaces. Connections can be made to files (most common) or to other more exotic things.

  • file, opens a connection to a file
  • gzfile, opens a connection to a file compressed with gzip
  • bzfile, opens a connection to a file compressed with bzip2
  • url, opens a connection to a webpage

File Connections

> str(file)
function (description = "", open = "", blocking = TRUE,
          encoding = getOption("encoding"))
  • description is the name of the file
  • open is a code indicating
  • “r” read only
  • “w” writing (and initializing a new file)
  • “a” appending
  • “rb”, “wb”, “ab” reading, writing, or appending in binary mode (Windows)

Connections

In general, connections are powerful tools that let you navigate files or other external objects. In practice, we often don’t need to deal with the connection interface directly.

con <- file("foo.txt", "r")
data <- read.csv(con)
close(con)

is the same as

data <- read.csv("foo.txt")

Reading Lines of a Text File

> con <- gzfile("words.gz") 
> x <- readLines(con, 10) 
> x
 [1] "1080"     "10-point" "10th"     "11-point"
 [5] "12-point" "16-point" "18-point" "1st"
 [9] "2"        "20-point"

writeLines takes a character vector and writes each element one line at a time to a text file.

Reading Lines of a Text File

readLines can be useful for reading in lines of webpages

## This might take time
con <- url("http://www.jhsph.edu", "r")
x <- readLines(con)
> head(x)
[1] "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">"
[2] ""
[3] "<html>"
[4] "<head>"
[5] "\t<meta http-equiv=\"Content-Type\" content=\"text/html;charset=utf-8